Advertisement
Guest User

Untitled

a guest
Oct 18th, 2018
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.47 KB | None | 0 0
  1. import pandas as pd
  2. path="https://cocl.us/datasciece_survey_data"
  3. survey1=pd.read_csv(path)
  4. survey1.columns
  5. survey1.drop(['Timestamp'],axis=1, inplace=True)
  6. column_names=survey1.columns.values
  7. column_names=survey1.columns.str.split("[").str[1]
  8. survey1.columns = column_names
  9. column_names1=survey1.columns.str.split("]").str[0]
  10. survey1.columns = column_names1
  11. final=survey1.apply(pd.Series.value_counts).transpose()
  12. final.sort_index(inplace=True, ascending=True)
  13. final
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement