Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # Column names
- columns_to_transpose_csv = str(sys.argv[2])
- id_columns_csv = str(sys.argv[3])
- variable_name = str(sys.argv[4])
- val_name = str(sys.argv[5])
- # pandas data melt and output to CSV
- fat_df = pd.read_csv('wide, fat CSV to read in')
- skinny_df = pd.melt(fat_df,id_vars='id_columns',var_name=variable_name,value_name=val_name,value_vars=column_to_transpose_list)
- skinny_df.to_csv("../output/" + fat_csv +'_transformed.csv',index=False)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement