How to convert column with list of values into rows in Pandas DataFrame

by

Pandas >= 0.25

df1 = pd.DataFrame({'A':['a','b'],
               'B':[[['1', '2']],[['3', '4', '5']]]})
print(df1)

    A   B
0   a   [[1, 2]]
1   b   [[3, 4, 5]]

df1 = df1.explode('B')
df1.explode('B')

    A   B
0   a   1
0   a   2
1   b   3
1   b   4
1   b   5

I don’t know how good this approach is but it works when you have a list of items.

More Related Contents:

  1. Why does the following code cant get value of n_fold = 1?
  2. How to change the order of DataFrame columns?
  3. Filter dataframe rows if value in column is in a set list of values [duplicate]
  4. Add missing dates to pandas dataframe
  5. Converting a Pandas GroupBy output from Series to DataFrame
  6. Pandas: sum DataFrame rows for given columns
  7. datetime dtypes in pandas read_csv
  8. Pandas DataFrame: replace all values in a column, based on condition
  9. Pandas – Slice large dataframe into chunks
  10. Calculate average of every x rows in a table and create new table
  11. Removing prefix from column names in Pandas
  12. How to remove square bracket from pandas dataframe
  13. Remove or replace spaces in column names
  14. pandas dataframe columns scaling with sklearn
  15. Python Pandas update a dataframe value from another dataframe
  16. Mapping columns from one dataframe to another to create a new column [duplicate]
  17. Action with pandas SettingWithCopyWarning
  18. python dataframe pandas drop column using int
  19. How to plot two columns of a pandas data frame using points
  20. which is faster for load: pickle or hdf5 in python
  21. How to read a list of parquet files from S3 as a pandas dataframe using pyarrow?
  22. Return multiple columns from pandas apply()
  23. Python Pandas – Merge based on substring in string
  24. Filling in date gaps in MultiIndex Pandas Dataframe
  25. append dictionary to data frame
  26. Find unique values in a Pandas dataframe, irrespective of row or column location
  27. What values are valid in Pandas ‘Freq’ tags?
  28. How to efficiently assign unique ID to individuals with multiple entries based on name in very large df
  29. start index at 1 for Pandas DataFrame
  30. Multi Index Sorting in Pandas

Leave a Comment