Splitting dataframe into multiple dataframes

by

Can I ask why not just do it by slicing the data frame. Something like

#create some data with Names column
data = pd.DataFrame({'Names': ['Joe', 'John', 'Jasper', 'Jez'] *4, 'Ob1' : np.random.rand(16), 'Ob2' : np.random.rand(16)})

#create unique list of names
UniqueNames = data.Names.unique()

#create a data frame dictionary to store your data frames
DataFrameDict = {elem : pd.DataFrame() for elem in UniqueNames}

for key in DataFrameDict.keys():
    DataFrameDict[key] = data[:][data.Names == key]

Hey presto you have a dictionary of data frames just as (I think) you want them. Need to access one? Just enter

DataFrameDict['Joe']

Hope that helps

More Related Contents:

  1. Pandas split DataFrame by column value
  2. Pandas split column into multiple columns by comma
  3. Quickest way to make a get_dummies type dataframe from a column with a multiple of strings
  4. Split pandas dataframe in two if it has more than 10 rows
  5. how to calculation cost time [closed]
  6. How to add a new column to an existing DataFrame?
  7. How to replace NaN values by Zeroes in a column of a Pandas Dataframe?
  8. Construct pandas DataFrame from items in nested dictionary
  9. What rules does Pandas use to generate a view vs a copy?
  10. How to extract multiple JSON objects from one file?
  11. Sorting columns in pandas dataframe based on column name [duplicate]
  12. Pandas DataFrame stored list as string: How to convert back to list
  13. What is the difference between using loc and using just square brackets to filter for columns in Pandas/Python?
  14. Find maximum value of a column and return the corresponding row values using Pandas
  15. Merge multiple column values into one column in python pandas
  16. How do I get the row count of a Pandas DataFrame?
  17. Pandas dataframe fillna() only some columns in place
  18. Apply CSS class to Pandas DataFrame using to_html
  19. Python – splitting dataframe into multiple dataframes based on column values and naming them with those values [duplicate]
  20. Shift NaNs to the end of their respective rows
  21. OSError: Initializing from file failed on csv in Pandas
  22. Convert column to row in Python Pandas
  23. Putting many python pandas dataframes to one excel worksheet
  24. Remove Unnamed columns in pandas dataframe [duplicate]
  25. Find difference between two data frames
  26. Create new column based on values from other columns / apply a function of multiple columns, row-wise in Pandas
  27. Pandas Dataframe: split column into multiple columns, right-align inconsistent cell entries
  28. Efficient way to add rows to dataframe
  29. Find names of top-n highest-value columns in each pandas dataframe row
  30. How to “select distinct” across multiple data frame columns in pandas?

Leave a Comment