GroupBy results to dictionary of lists

by

You could groupby on Column1 and then take Column3 to apply(list) and call to_dict?

In [81]: df.groupby('Column1')['Column3'].apply(list).to_dict()
Out[81]: {0: [1], 1: [2, 3, 5], 2: [1, 2], 3: [4, 5], 4: [1], 5: [1, 2, 3]}

Or, do

In [433]: {k: list(v) for k, v in df.groupby('Column1')['Column3']}
Out[433]: {0: [1], 1: [2, 3, 5], 2: [1, 2], 3: [4, 5], 4: [1], 5: [1, 2, 3]}

More Related Contents:

  1. Pandas: Looking up the list of sheets in an excel file
  2. How to obtain sheet names from XLS files without loading the whole file?
  3. xlrd.biffh.XLRDError: Excel xlsx file; not supported [duplicate]
  4. python: update dataframe to existing excel sheet without overwriting contents on the same sheet and other sheets
  5. converting a text file to csv file with out index
  6. Extract the data and modify an existing excel with openpyxl
  7. How to drop rows of Pandas DataFrame whose value in a certain column is NaN
  8. Fast Haversine Approximation (Python/Pandas)
  9. Python matplotlib multiple bars
  10. Pandas column access w/column names containing spaces
  11. How to get value counts for multiple columns at once in Pandas DataFrame?
  12. Add x and y labels to a pandas plot
  13. Plot different DataFrames in the same figure
  14. Pandas DataFrame stack multiple column values into single column
  15. How to apply a function on every row on a dataframe?
  16. How to implement sql coalesce in pandas
  17. Pandas still getting SettingWithCopyWarning even after using .loc
  18. Subtract a year from a datetime column in pandas
  19. How to calculate correlation between all columns and remove highly correlated ones using pandas?
  20. Python Pandas merge samed name columns in a dataframe
  21. Create bool mask from filter results in Pandas [duplicate]
  22. Getting a list of indices where pandas boolean series is True
  23. How can I remove extra whitespace from strings when parsing a csv file in Pandas?
  24. convert entire pandas dataframe to integers in pandas (0.17.0)
  25. TfidfVectorizer in scikit-learn : ValueError: np.nan is an invalid document
  26. Pandas Correlation Groupby
  27. pandas, melt, unmelt preserve index
  28. Conditional row read of csv in pandas
  29. Python: Adding hours to pandas timestamp
  30. Creating multiple Excel worksheets using data from a pandas DataFrame

Leave a Comment