All possible combinations of columns in dataframe -pandas/python

by

You can use:

from itertools import combinations
df = df.set_index('Dt')

cc = list(combinations(df.columns,2))
df = pd.concat([df[c[1]].sub(df[c[0]]) for c in cc], axis=1, keys=cc)
df.columns = df.columns.map(''.join)
print (df)
        AB  AC  AD  BC  BD  CD
Dt                            
11-apr   0   0   0   0   0   0
10-apr   1  -1   0  -2  -1   1

More Related Contents:

  1. How do I melt a pandas dataframe?
  2. How to split data into 3 sets (train, validation and test)?
  3. Requirements for converting Spark dataframe to Pandas/R dataframe
  4. pandas reading CSV data formatted with comma for thousands separator
  5. Pandas: add a column to a multiindex column dataframe
  6. Pandas – Find and index rows that match row sequence pattern
  7. Trouble installing Pandas on new MacBook Air M1
  8. (pandas) Create new column based on first element in groupby object
  9. Pandas, group by count and add count to original dataframe?
  10. Jupyter notebook display two pandas tables side by side
  11. Adding a column thats result of difference in consecutive rows in pandas
  12. using time zone in pandas to_datetime
  13. collect() or toPandas() on a large DataFrame in pyspark/EMR
  14. Kalman filter with varying timesteps
  15. Pandas: fill in NaN values with dictionary references another column
  16. Standard implementation of vectorize_sequences
  17. Why does it take ages to install Pandas on Alpine Linux
  18. Suppress output of object when plotting in IPython
  19. Splitting multiple columns into rows in pandas dataframe
  20. Convert a spark DataFrame to pandas DF
  21. Pandas- Select rows from DataFrame based on condition
  22. Pandas & AWS Lambda
  23. Scrape tables into dataframe with BeautifulSoup
  24. How to remove illegal characters so a dataframe can write to Excel
  25. Plot pandas dataframe containing NaNs
  26. Turn pandas dataframe into a file-like object in memory?
  27. How can I left justify text in a pandas DataFrame column in an IPython notebook
  28. concise way of flattening multiindex columns
  29. use Featureunion in scikit-learn to combine two pandas columns for tfidf
  30. Convert dataframe with start and end date to daily data

Leave a Comment