def q04_mapping(path1, path2):
'write your solution here'
df_final = q02_append_row(path1)
scraped = pd.read_csv(path2)
print(df_final.head())
print(scraped.head())
scraped['United States of America'] = scraped[
'United States of America'].astype(str).apply(lambda x: x.lower())
scraped['US'] = scraped['US'].astype(str)
mapping = scraped.set_index('United States of America')['US'].to_dict()
df_final.insert(6, 'abbr', np.nan)
df_final['abbr'] = df_final['state'].map(mapping)
return df_final
def q04_mapping(path1,path2):
df_from_appended_row = q02_append_row(path1)
df_from_scraped_data = q03_scrape_clean(path2)
#Approach 1 for creating a dictionary
mapping = df_from_scraped_data.set_index('United States of America').to_dict()['U.S.']
mapping = {k.lower(): v for k,v in mapping.items()}
df_final = df_from_appended_row
#Inseting 'abbr' at column 6 - Approach 2 for this is given below
df_final.insert(6, 'abbr', '')
df_final['abbr'] = df_final['state'].map(mapping)
return df_final
def q04_mapping(path1,path2):
a = pd.read_excel(path1)
b = pd.read_csv(path2)
b['United States of America'] = b['United States of America'].astype(str).str.lower()
b['US'] = b['US'].astype(str)
mapping = b.set_index('United States of America').to_dict()['US']
mapping['mississipi']=mapping.pop('mississippi')
mapping['tenessee']=mapping.pop('tennessee')
new_df = q02_append_row(path1)
# new['abbr'] = np.nan
new_df.insert(loc = 6,column = 'abbr', value = np.nan)
new_df['state'] = new_df['state'].map(mapping)
return new_df
def q04_mapping(path1,path2):
df1 = q02_append_row(path1)
df1['abbr'] = np.nan
df2 = pd.read_csv(path2)
ab = df2.iloc[:,7]
name = df2['United States of America']
d = {}
for i in range(0,ab.shape[0]):
d[name[i].lower()] = ab[i]
for i in range(0,df1.shape[0]):
if df1.iloc[i,:]['state'] in d.keys():
df1.iloc[i,-1] = d[df1.iloc[i,:]['state']]
df2 = df1.iloc[:,0:5]
df2['total'] = df1['total']
df2['abbr'] = df1['abbr']
return df2
def q04_mapping(path1, path2):
"write your solution here"
df1 = q02_append_row(path1)
df2 = q03_scrape_clean(path2)
return df1, df2