Skip to content

Instantly share code, notes, and snippets.

@exy02

exy02/data_vis_mining_2_cleaning_2.py

Last active September 25, 2020 05:40
Show Gist options
  • Save exy02/95a4d58bb64d579823b2f8348ad3ddfa to your computer and use it in GitHub Desktop.
Save exy02/95a4d58bb64d579823b2f8348ad3ddfa to your computer and use it in GitHub Desktop.
Download ZIP
How to Extract Data from Online Data Visualizations - 2. Data Cleaning _2
Raw
data_vis_mining_2_cleaning_2.py
json_df = pd.DataFrame(json_list,columns=["new"])
json_df = json_df["new"].str.split(",", expand = True)
col_names = ['Measure','County','Test Date','Positives','Death Count','Cumulative Positives',
'Cumulative Deaths','Moving Average (Cases)','Moving Average (Deaths)']
json_df.columns = col_names
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment