Split dataframe into relatively even chunks according to length

by

You can take the floor division of a sequence up to the amount of rows in the dataframe, and use it to groupby splitting the dataframe into equally sized chunks:

n = 400
for g, df in test.groupby(np.arange(len(test)) // n):
    print(df.shape)
# (400, 2)
# (400, 2)
# (311, 2)

More Related Contents:

  1. Pandas percentage of total with groupby
  2. Scatter plots in Pandas/Pyplot: How to plot by category [duplicate]
  3. Using Pandas to pd.read_excel() for multiple worksheets of the same workbook
  4. How to add pandas data to an existing csv file?
  5. How to explode a list inside a Dataframe cell into separate rows
  6. How do I operate on a DataFrame with a Series for every column?
  7. Pandas split column into multiple columns by comma
  8. Repeat rows in a pandas DataFrame based on column value
  9. Accessing every 1st element of Pandas DataFrame column containing lists
  10. Dropping infinite values from dataframes in pandas?
  11. How to use groupby to concatenate strings in python pandas?
  12. Horizontal stacked bar plot and add labels to each section
  13. How to flatten a nested JSON recursively, with flatten_json
  14. How to invoke pandas.rolling.apply with parameters from multiple column?
  15. Convert commas decimal separators to dots within a Dataframe
  16. How to remove timezone from a Timestamp column in a pandas dataframe
  17. Pandas lookup from one of multiple columns, based on value
  18. ‘utf-8’ codec can’t decode byte 0x92 in position 18: invalid start byte
  19. Pandas – Compute z-score for all columns
  20. How can I use cumsum within a group in Pandas?
  21. Why does df.apply(tuple) work but not df.apply(list)?
  22. Plot multiple columns of pandas DataFrame on the bar chart
  23. How to get unique values from multiple columns in a pandas groupby
  24. Merge a list of pandas dataframes
  25. How do I delete a column that contains only zeros in Pandas?
  26. How to repeat a Pandas DataFrame?
  27. Pandas ParserError EOF character when reading multiple csv files to HDF5
  28. Get column name where value is something in pandas dataframe
  29. How to compute jaccard similarity from a pandas dataframe
  30. How to convert DataFrame.append() to pandas.concat()?

Leave a Comment