问题

emptylist = [{'data': {'id': 7478290440, 'version': 0, 'bonus_opening_balance': 7.4, 'cash_opening_balance': 30.83, 'external_round_id': '8997958938', 'game_id': 29788, 'game_session_id': 144418070, 'last_updated_at': '2023-06-29T14:03:03Z', 'started_at': '2023-06-29T14:03:03Z', 'status': 0, 'cash_stake': 0, 'cash_win': 0, 'bonus_stake': 0, 'bonus_win': 0}, 'metadata': {'timestamp': '2023-06-29T12:03:07.699650Z', 'record-type': 'data', 'operation': 'insert', 'partition-key-type': 'schema-table', 'schema-name': 'revolve', 'table-name': 'game_round', 'transaction-id': 103414267563647}}, {'data': {'id': 7478290359, 'version': 2, 'bonus_opening_balance': 0, 'cash_opening_balance': 11.13, 'ended_at': '2023-06-29T14:03:03Z', 'external_round_id': '8997958480', 'game_id': 16210, 'game_session_id': 144418025, 'last_updated_at': '2023-06-29T14:03:03Z', 'started_at': '2023-06-29T14:02:58Z', 'status': 1, 'cash_stake': 0.2, 'cash_win': 0.03, 'bonus_stake': 0, 'bonus_win': 0}, 'metadata': {'timestamp': '2023-06-29T12:03:07.708711Z', 'record-type': 'data', 'operation': 'update', 'partition-key-type': 'schema-table', 'schema-name': 'revolve', 'table-name': 'game_round', 'transaction-id': 103414267564722}}, {'data': {'id': 7478290440, 'version': 1, 'bonus_opening_balance': 7.4, 'cash_opening_balance': 30.83, 'external_round_id': '8997958938', 'game_id': 29788, 'game_session_id': 144418070, 'last_updated_at': '2023-06-29T14:03:03Z', 'started_at': '2023-06-29T14:03:03Z', 'status': 0, 'cash_stake': 0.2, 'cash_win': 0, 'bonus_stake': 0, 'bonus_win': 0}, 'metadata': {'timestamp': '2023-06-29T12:03:07.717096Z', 'record-type': 'data', 'operation': 'update', 'partition-key-type': 'schema-table', 'schema-name': 'revolve', 'table-name': 'game_round', 'transaction-id': 103414267565254}}]

英文:

I have a list that contains nested json data and I would like to convert everything that is in the 'data:' tag into a data frame. The list contains multiple records inside the

emptylist = [{&#39;data&#39;: {&#39;id&#39;: 7478290440, &#39;version&#39;: 0, &#39;bonus_opening_balance&#39;: 7.4, &#39;cash_opening_balance&#39;: 30.83, &#39;external_round_id&#39;: &#39;8997958938&#39;, &#39;game_id&#39;: 29788, &#39;game_session_id&#39;: 144418070, &#39;last_updated_at&#39;: &#39;2023-06-29T14:03:03Z&#39;, &#39;started_at&#39;: &#39;2023-06-29T14:03:03Z&#39;, &#39;status&#39;: 0, &#39;cash_stake&#39;: 0, &#39;cash_win&#39;: 0, &#39;bonus_stake&#39;: 0, &#39;bonus_win&#39;: 0}, &#39;metadata&#39;: {&#39;timestamp&#39;: &#39;2023-06-29T12:03:07.699650Z&#39;, &#39;record-type&#39;: &#39;data&#39;, &#39;operation&#39;: &#39;insert&#39;, &#39;partition-key-type&#39;: &#39;schema-table&#39;, &#39;schema-name&#39;: &#39;revolve&#39;, &#39;table-name&#39;: &#39;game_round&#39;, &#39;transaction-id&#39;: 103414267563647}}, {&#39;data&#39;: {&#39;id&#39;: 7478290359, &#39;version&#39;: 2, &#39;bonus_opening_balance&#39;: 0, &#39;cash_opening_balance&#39;: 11.13, &#39;ended_at&#39;: &#39;2023-06-29T14:03:03Z&#39;, &#39;external_round_id&#39;: &#39;8997958480&#39;, &#39;game_id&#39;: 16210, &#39;game_session_id&#39;: 144418025, &#39;last_updated_at&#39;: &#39;2023-06-29T14:03:03Z&#39;, &#39;started_at&#39;: &#39;2023-06-29T14:02:58Z&#39;, &#39;status&#39;: 1, &#39;cash_stake&#39;: 0.2, &#39;cash_win&#39;: 0.03, &#39;bonus_stake&#39;: 0, &#39;bonus_win&#39;: 0}, &#39;metadata&#39;: {&#39;timestamp&#39;: &#39;2023-06-29T12:03:07.708711Z&#39;, &#39;record-type&#39;: &#39;data&#39;, &#39;operation&#39;: &#39;update&#39;, &#39;partition-key-type&#39;: &#39;schema-table&#39;, &#39;schema-name&#39;: &#39;revolve&#39;, &#39;table-name&#39;: &#39;game_round&#39;, &#39;transaction-id&#39;: 103414267564722}}, {&#39;data&#39;: {&#39;id&#39;: 7478290440, &#39;version&#39;: 1, &#39;bonus_opening_balance&#39;: 7.4, &#39;cash_opening_balance&#39;: 30.83, &#39;external_round_id&#39;: &#39;8997958938&#39;, &#39;game_id&#39;: 29788, &#39;game_session_id&#39;: 144418070, &#39;last_updated_at&#39;: &#39;2023-06-29T14:03:03Z&#39;, &#39;started_at&#39;: &#39;2023-06-29T14:03:03Z&#39;, &#39;status&#39;: 0, &#39;cash_stake&#39;: 0.2, &#39;cash_win&#39;: 0, &#39;bonus_stake&#39;: 0, &#39;bonus_win&#39;: 0}, &#39;metadata&#39;: {&#39;timestamp&#39;: &#39;2023-06-29T12:03:07.717096Z&#39;, &#39;record-type&#39;: &#39;data&#39;, &#39;operation&#39;: &#39;update&#39;, &#39;partition-key-type&#39;: &#39;schema-table&#39;, &#39;schema-name&#39;: &#39;revolve&#39;, &#39;table-name&#39;: &#39;game_round&#39;, &#39;transaction-id&#39;: 103414267565254}}]
print(emptylist)

答案1

得分: 0

尝试这个

import pandas as pd
emptylist = [{'data': ... }]
data_list = [record['data'] for record in emptylist]
df = pd.DataFrame(data_list)
print(df)

英文:

Try this

import pandas as pd
emptylist = [{&#39;data&#39;: ... }]
data_list = [record[&#39;data&#39;] for record in emptylist]
df = pd.DataFrame(data_list)
print(df)

答案2

得分: 0

pd.DataFrame(emptylist)[ "data" ].apply(pd.Series)

英文:

You could create a DataFrame from the list and use apply on the "data" series to make it a DataFrame:

pd.DataFrame(emptylist)[&quot;data&quot;].apply(pd.Series)

通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。

Python – 将JSON列表转换为数据框

问题

答案1

答案2

日期替换 Pandas

python中的`isalpha()`未定义，尽管它是内置的（我认为）。

在一个隔离环境中的 pyproject.toml

Pandas- 分组字符串数值

What's the correct way to type hint an empty list as a literal in python?

如何在Highcharts Gantt中更改本地化的星期名称

如何在同一个流中使用多个过滤器和映射函数？

如何使用Map/Set来将代码优化到O(n)？

.NET MAUI Android在GitHub Actions上构建失败，错误代码为1。

如何在Playwright视觉比较中屏蔽多个定位器？

在C++中，可以使用可变模板参数来检索类型的内部类型。

selenium.common.exceptions.StaleElementReferenceException: Message: stale element reference: stale element not found

Creating and opening a URL to log in to Website via Basic Auth with Robot Framework/Selenium (Python)

AG Grid 在上下文菜单中以大文本形式打开

发表评论