Learn practical skills, build real-world projects, and advance your career
Updated 5 years ago
import jovian
import tensorflow
import pandas as pddf_unspsc = pd.read_csv('data/unspsc.csv', encoding='utf-8')
df_unspsc.sort_values(by=['Commodity'])
df_unspsc.head(10)df_unspsc_mod = pd.DataFrame(index=None, data=None, columns=['DisplayName', 'Code', 'Type'])df_segment = pd.DataFrame(df_unspsc.drop_duplicates(['SegmentName','Segment'])[['SegmentName','Segment']]).reset_index(drop=True)
df_segment = df_segment.rename(columns={"SegmentName": "DisplayName", "Segment": "Code"})
df_segment['Type'] = 'Segment'df_family = pd.DataFrame(df_unspsc.drop_duplicates(['FamilyName','Family'])[['FamilyName','Family']]).reset_index(drop=True)
df_family = df_family.rename(columns={"FamilyName": "DisplayName", "Family": "Code"})
df_family['Type'] = 'Family'