Advertisement
Guest User

Untitled

a guest
Jul 18th, 2019
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.43 KB | None | 0 0
  1. # Column names
  2. columns_to_transpose_csv = str(sys.argv[2])
  3. id_columns_csv = str(sys.argv[3])
  4. variable_name = str(sys.argv[4])
  5. val_name = str(sys.argv[5])
  6.  
  7. # pandas data melt and output to CSV
  8. fat_df = pd.read_csv('wide, fat CSV to read in')
  9. skinny_df = pd.melt(fat_df,id_vars='id_columns',var_name=variable_name,value_name=val_name,value_vars=column_to_transpose_list)
  10. skinny_df.to_csv("../output/" + fat_csv +'_transformed.csv',index=False)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement