Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import pandas as pd
- path="https://cocl.us/datasciece_survey_data"
- survey1=pd.read_csv(path)
- survey1.columns
- survey1.drop(['Timestamp'],axis=1, inplace=True)
- column_names=survey1.columns.values
- column_names=survey1.columns.str.split("[").str[1]
- survey1.columns = column_names
- column_names1=survey1.columns.str.split("]").str[0]
- survey1.columns = column_names1
- final=survey1.apply(pd.Series.value_counts).transpose()
- final.sort_index(inplace=True, ascending=True)
- final
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement