Converting to xlsx from json?

[andreastasia]

Hi everyone,

I am a very beginner in Python. I am using this package but I'd love to save the outputs in xlsx format (for a better reading). I saved the JSON outputs in files but the conversion using pandas or online converter is ugly.

What I would to do is to have an Excel file with per every row I have the different tickers and the columns are the different metrics, as below:

Is possibile to do in some ways?

Thank you! Andrea

[andreastasia]

`from yahoofinancials import YahooFinancials

ticker = ['INC.MI', 'BSS.MI'] yahoo_financials = YahooFinancials(ticker)

keystatistics = yahoo_financials.get_key_statistics_data()

import json with open('data.json', 'w', encoding='utf-8') as f: json.dump(keystatistics, f, ensure_ascii=False, indent=4)`

This is my code, if it can help you.

[sylvandb]

Instead of doing a json.dump(), you probably need to write a CSV file, then Excel can import the CSV. Something like:

headings = []
for t, d in keystatistics.items():
  headings.extend(d.keys())
headings = list(set(headings))
with open('data.csv', 'w', encoding='utf-8') as f:
  f.write('"ticker","%s"\n' % ('","'.join(headings),))
  for t, d in keystatistics.items():
    f.write('"%s"' % t)
    for h in headings:
      f.write(',"%s"' % (d.get(h) or '',))
    f.write('\n')

[JECSand]

@andreastasia you can also leverage the XlsxWriter package for this.

https://pypi.org/project/XlsxWriter/