Pandas: split column of lists of unequal length into multiple columns

by

Try:

pd.DataFrame(df.codes.values.tolist()).add_prefix('code_')

   code_0   code_1   code_2
0   71020      NaN      NaN
1   77085      NaN      NaN
2   36415      NaN      NaN
3   99213  99287.0      NaN
4   99233  99233.0  99233.0

Include the index

pd.DataFrame(df.codes.values.tolist(), df.index).add_prefix('code_')

   code_0   code_1   code_2
1   71020      NaN      NaN
2   77085      NaN      NaN
3   36415      NaN      NaN
4   99213  99287.0      NaN
5   99233  99233.0  99233.0

We can nail down all the formatting with this:

f = lambda x: 'code_{}'.format(x + 1)
pd.DataFrame(
    df.codes.values.tolist(),
    df.index, dtype=object
).fillna('').rename(columns=f)

   code_1 code_2 code_3
1   71020              
2   77085              
3   36415              
4   99213  99287       
5   99233  99233  99233

More Related Contents:

  1. Clustered Stacked Bar in Python Pandas [closed]
  2. How to add a new column to an existing DataFrame?
  3. Python Pandas – Find difference between two data frames
  4. Convert pandas timezone-aware DateTimeIndex to naive timestamp, but in certain timezone
  5. Pandas groupby cumulative sum
  6. Pandas DataFrame concat vs append
  7. Use pandas.shift() within a group
  8. What is the most efficient way of counting occurrences in pandas?
  9. Pandas read csv file with float values results in weird rounding and decimal digits
  10. pandas – filter dataframe by another dataframe by row elements
  11. Pandas interpolate within a groupby
  12. Left justify string values in a pandas DataFrame
  13. Python Pandas: How to read only first n rows of CSV files in?
  14. Pandas – replacing column values
  15. add columns different length pandas
  16. Pandas get the age from a date (example: date of birth)
  17. How to create a grouped bar plot
  18. Sample each group after pandas groupby
  19. Python Pandas – Missing required dependencies [‘numpy’] 1
  20. Pandas Data Frame how to merge columns
  21. Bar graph from dataframe groupby
  22. What are the differences between feather and parquet?
  23. Reading multiple JSON records into a Pandas dataframe
  24. Grouped Bar graph Pandas
  25. Find names of top-n highest-value columns in each pandas dataframe row
  26. pandas group by and assign a group id then ungroup
  27. Add column of empty lists to DataFrame
  28. Clean way to convert quarterly periods to datetime in pandas
  29. Combine Pandas data frame column values into new column
  30. Is it possible to add a string as a legend item

Leave a Comment