how to transform a json file to a pandas dataframe

Asked Jun 12 '23 at 15:04

Active Jun 12 '23 at 15:04

Viewed 19 times

I have a json file that I would like to transform it as pandas dataframe. the json file is:

{'lastUpdated': {'epochUnixSeconds': 1686580918,
  'humanDate': '2023-06-12T14:41:58.000Z'},
 'fgi': {'now': {'value': 78, 'valueText': 'Extreme Greed'},
  'previousClose': {'value': 77, 'valueText': 'Extreme Greed'},
  'oneWeekAgo': {'value': 73, 'valueText': 'Greed'},
  'oneMonthAgo': {'value': 57, 'valueText': 'Greed'},
  'oneYearAgo': {'value': 40, 'valueText': 'Fear'}}}

How to convert this json file into a pandas dataframe ?

asked Jun 12 '23 at 15:04

jacques

What should the output look like? – NYC Coder Jun 12 '23 at 15:06
I would like to have the value / ValueText for each column and now / previousClose / oneWeekAgo / oneMonthAgo / oneYearAgo as index – jacques Jun 12 '23 at 15:15

how to transform a json file to a pandas dataframe

0 Answers0