Guest User

Untitled

a guest
Jun 18th, 2018
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.52 KB | None | 0 0
  1. df["column"].value_counts(False).to_dict()
  2.  
  3. #Import dependencies
  4. import numpy as np
  5. import pandas as pd
  6.  
  7. #Create dataframe with random data
  8. df = pd.DataFrame(np.random.randint(0,100,size=(100, 4)), columns=list('ABCD'))
  9.  
  10. #Create a 'result dataframe'
  11. resultDf = pd.DataFrame(columns=list(df.keys()))
  12.  
  13. #Append value-count pairs to new dataframe
  14. for column in df.keys():
  15. _dict_ = df[column].value_counts(False).to_dict()
  16. for index, key in enumerate(_dict_):
  17. resultDf.loc[index, column] = [key,_dict_.get(key)]
Add Comment
Please, Sign In to add comment