Read racecards json with pandas

[goldieiii]

Hi,
i try to read the racecards JSON file into pandas Dataframe. But there are no index keys. Can someone help me out?

Here is an example:

Thanks

goldie

[rmwesley99]

Here you go... attached code will do what you are looking for. It is exported from Jupyter Notebook > PDF.
To give credit where it is due, I hacked this from a post on one of the betting forums (either UK Betting Forum or OLBG) however I can't for the life of me find it now to give the original author the kudos.
racecard_json2csv.pdf

[goldieiii]

Thank you very much.

[Caprice63]

That's great. Much appreciated.

[Caprice63]

Hi, i try to read the racecards JSON file into pandas Dataframe. But there are no index keys. Can someone help me out?

This may be of use:
There is a routine that scrapes odds and adds them to a csv/ xlsx file.

I'm not conversant with GitHub so my apologies if this is not the right way to do this.
link to code
https://github.com/Caprice63/rpscrape_dataframes/blob/master/racecards_menu_odds.py

I've added the start of a menu structure to the https://github.com/joenano/rpscrape file (racecards .json). I've added "trainer_14_days" info. and the latest medical info (however, I need to find a way to add these and "cdbf" to the .json file)
I've also managed to incorporate a conversion to .xlsx
Also, there is a routine that scrapes odds and adds them to the .xlsx file.

The file shows text to indicate progress as it seems to run a little slow and I like to see where it is up to.

It is a bit untidy and would probably benefit from being called from a separate file.

However, it may be of use in its current form