How to melt 2 columns at the same time?

by

This is wide_to_long

pd.wide_to_long(df,['t','l'],i=['id1','id2'],j='drop').reset_index(level=[0,1])
Out[52]: 
      id1  id2  t  l
drop                
1       1    2  a  b
2       1    2  c  d
1       3    4  g  h
2       3    4  i  j

More Related Contents:

  1. How to change column names from numbers to names [closed]
  2. How to provide a reproducible copy of your DataFrame with to_clipboard()
  3. Pandas groupby with delimiter join
  4. How to plot multiple Seaborn Jointplot in Subplot
  5. Find column whose name contains a specific string
  6. pandas: merge (join) two data frames on multiple columns
  7. Pandas Extract Number from String
  8. Conditionally fill column values based on another columns value in pandas
  9. No module named ‘pandas._libs.tslibs.timedeltas’ in PyInstaller
  10. Pandas deleting row with df.drop doesn’t work
  11. How to translate “bytes” objects into literal strings in pandas Dataframe, Python3.x?
  12. Count number of words per row
  13. pandas or python equivalent of tidyr complete
  14. Python pandas: remove everything after a delimiter in a string
  15. python pandas read_csv delimiter in column data
  16. Pandas number rows within group in increasing order
  17. pandas.read_csv from string or package data
  18. Python pandas: how to remove nan and -inf values
  19. Pandas ParserError EOF character when reading multiple csv files to HDF5
  20. Plot two levels of x_ticklabels on a pandas multi-index dataframe [duplicate]
  21. Format a number with commas to separate thousands
  22. Create a pandas DataFrame from generator?
  23. reading multiple files contained in a zip file with pandas
  24. How to compute jaccard similarity from a pandas dataframe
  25. Search and replace dots and commas in pandas dataframe
  26. How to convert string representation of dictionary in Pandas DataFrame to a new columns?
  27. Python Pandas – Lookup a variable column depending on another column’s value
  28. Why do I get a KeyError when using pandas apply?
  29. pandas scatter plotting datetime
  30. Pandas(Python) : Fill empty cells with with previous row value?

Leave a Comment