How to concatenate multiple column values into a single column in Pandas dataframe

by

Another solution using DataFrame.apply(), with slightly less typing and more scalable when you want to join more columns:

cols = ['foo', 'bar', 'new']
df['combined'] = df[cols].apply(lambda row: '_'.join(row.values.astype(str)), axis=1)

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. Add missing dates to pandas dataframe
  4. Converting a Pandas GroupBy output from Series to DataFrame
  5. Pandas: sum DataFrame rows for given columns
  6. datetime dtypes in pandas read_csv
  7. Rename Pandas DataFrame Index
  8. Pandas DataFrame: replace all values in a column, based on condition
  9. What is the fastest way to upload a big csv file in notebook to work with python pandas?
  10. Calculate average of every x rows in a table and create new table
  11. How to check if any value is NaN in a Pandas DataFrame
  12. Convert row to column header for Pandas DataFrame,
  13. Removing prefix from column names in Pandas
  14. Select multiple ranges of columns in Pandas DataFrame
  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. How can I replicate rows in Pandas?
  18. Action with pandas SettingWithCopyWarning
  19. python dataframe pandas drop column using int
  20. How to create a DataFrame of random integers with Pandas?
  21. How to plot two columns of a pandas data frame using points
  22. How to read a list of parquet files from S3 as a pandas dataframe using pyarrow?
  23. Create new column based on values from other columns / apply a function of multiple columns, row-wise in Pandas
  24. Python Pandas – Merge based on substring in string
  25. append dictionary to data frame
  26. Pandas groupby and aggregation output should include all the original columns (including the ones not aggregated on)
  27. Selecting a range of columns in a dataframe
  28. Replace NaN with empty list in a pandas dataframe
  29. Get weekday/day-of-week for Datetime column of DataFrame
  30. When is it appropriate to use df.value_counts() vs df.groupby(‘…’).count()?

Leave a Comment