Pandas explode multiple columns [duplicate]

by

You could set col1 as index and apply pd.Series.explode across the columns:

df.set_index('col1').apply(pd.Series.explode).reset_index()

Or:

df.apply(pd.Series.explode)


   col1 col2 col3
0    aa    1  1.1
1    aa    2  2.2
2    aa    3  3.3
3    bb    4  4.4
4    bb    5  5.5
5    bb    6  6.6
6    cc    7  7.7
7    cc    8  8.8
8    cc    9  9.9
9    cc    7  7.7
10   cc    8  8.8
11   cc    9  9.9

More Related Contents:

  1. Get statistics for each group (such as count, mean, etc) using pandas GroupBy?
  2. Import multiple csv files into pandas and concatenate into one DataFrame
  3. Use a list of values to select rows from a Pandas dataframe
  4. Convert a Pandas DataFrame to a dictionary
  5. Set value for particular cell in pandas DataFrame using index
  6. how to sort pandas dataframe from one column
  7. Pandas read_csv low_memory and dtype options
  8. Compare two columns using pandas
  9. Pandas column access w/column names containing spaces
  10. Add x and y labels to a pandas plot
  11. python pandas extract year from datetime: df[‘year’] = df[‘date’].year is not working
  12. Pandas DataFrame stack multiple column values into single column
  13. How to replace negative numbers in Pandas Data Frame by zero
  14. Python Pandas Group by date using datetime data
  15. Removing the timestamp from a datetime in pandas dataframe
  16. Convert pandas data frame to series
  17. pandas comparison raises TypeError: cannot compare a dtyped [float64] array with a scalar of type [bool]
  18. vectorize conditional assignment in pandas dataframe
  19. Pandas DataFrame merge summing column
  20. Binning a column with pandas
  21. How do I filter a pandas DataFrame based on value counts?
  22. Lambda including if…elif…else
  23. How can I replicate rows of a Pandas DataFrame?
  24. Pandas query function not working with spaces in column names
  25. How to get/set a pandas index column title or name?
  26. Pandas DataFrame sort by categorical column but by specific class ordering
  27. Python pandas integer YYYYMMDD to datetime
  28. Pandas: drop columns with all NaN’s
  29. In Python pandas, start row index from 1 instead of zero without creating additional column
  30. Remove NaN values from pandas dataframe and reshape table [duplicate]

Leave a Comment