mirror of
https://github.com/chemistry-software/Periodic-Table-JSON.git
synced 2026-11-07 09:17:31 +00:00
AmirAli
0108a31e9a
* added: group, wxpos (wide x position), wypos(wide y position), block * update: README.md
22 lines
501 B
Python
Executable File
22 lines
501 B
Python
Executable File
#!/usr/bin/env python3
|
|
"""
|
|
Convert the JSON data to CSV
|
|
"""
|
|
|
|
import json
|
|
import pandas
|
|
|
|
PERIODIC_TABLE_CSV = "../PeriodicTableCSV.csv"
|
|
|
|
# Validate and load data
|
|
from validate_json import PERIODIC_TABLE_JSON
|
|
with open(PERIODIC_TABLE_JSON) as jfile:
|
|
jdata = json.load(jfile)["elements"]
|
|
|
|
# Normalize and save to CSV
|
|
# See: https://stackoverflow.com/a/58648286/2038713
|
|
df = pandas.json_normalize(jdata)
|
|
print(df)
|
|
df.to_csv(PERIODIC_TABLE_CSV, index=False)
|
|
print(f"CSV saved to {PERIODIC_TABLE_CSV}")
|