Data analysis on .json file in Python

Question

I have to analyse a .json file which looks like this:

{"columns":["id","timestamp","offset_freq","reprate_freq"],
"index":[0,1,2,3,4,5,6,7 ... 
"data":[[526144,1451900097533,20000000.495000001,250000093.9642499983],[...    }

it has over 600000 indexes so I dont want to show you the whole file.

I have found out that I can read the file simply by:

df = pd.read_json(file_name_or_Python_string, orient='split')

But what do I do now if I want to do some math on one of the columns? For example devide all the offset_freq by 2?

jay s · Accepted Answer · 2016-02-26 17:47:21Z

1

to divide 'offset_freq' by 2:

df['offset_freq']/2

I suggest you read 10 minutes to pandas for a quick pandas primer

http://pandas.pydata.org/pandas-docs/stable/10min.html

answered Feb 26, 2016 at 17:47

jay s

5315 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

ubadub · Accepted Answer · 2016-02-26 17:43:11Z

0

You'll want to parse the json and save into python data structures or objects for easy manipulation. How exactly you want to implement that depends on your needs and preferences.

answered Feb 26, 2016 at 17:43

ubadub

3,91024 silver badges36 bronze badges

Collectives™ on Stack Overflow

Data analysis on .json file in Python

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related