preprocess covid data for flourish

preprocess

df_conf.drop(['Province/State','Lat', 'Long'],axis=1, inplace=True)
df_c=pd.DataFrame(columns=df_conf.columns)
df_c['Country/Region']=country_list


for col_name in df_c.keys()[1:]:
    for ctry in country_list:
        x=df_conf[col_name][df_conf["Country/Region"]==ctry].sum()
        df_c[col_name][df_c['Country/Region']==ctry]=x
        
        
df_c['region']=""
df_c['Image']=""

for ctry in df_c['Country/Region'].unique():
    df_c['region'][df_c['Country/Region']==ctry]=str(fl_data.region[fl_data['Country Name']==ctry].sum())
    df_c['Image'][df_c['Country/Region']==ctry]=str(fl_data['Image URL'][fl_data['Country Name']==ctry].sum())

preprocess gist for medium