Rename columns in Pandas based on a dictionary

by

df.rename has a parameter called columns that accepts dictionaries:

df.rename(columns=dict(zip(df2["val1"], df2["val2"])))

Out:

    A7  B0  C3  D1
0   1   2   3   4
1   5   6   7   8

It returns a new DataFrame. You can either use inplace=True, or assign it back to the original DataFrame.

More Related Contents:

  1. Remap values in pandas column with a dict, preserve NaNs
  2. Renaming column names in Pandas
  3. Split / Explode a column of dictionaries into separate columns with pandas
  4. Reverse / invert a dictionary mapping
  5. Convert list of dictionaries to a pandas DataFrame
  6. What is the best way to implement nested dictionaries?
  7. Convert a Pandas DataFrame to a dictionary
  8. Replace values in a pandas series via dictionary efficiently
  9. Rename Pandas DataFrame Index
  10. How to convert a dataframe to a dictionary
  11. Pandas DataFrame to List of Dictionaries
  12. How do you create nested dict in Python?
  13. How do I exchange keys with values in a dictionary? [duplicate]
  14. Rename specific column(s) in pandas
  15. Convert row to column header for Pandas DataFrame,
  16. Nested dictionary to multiindex dataframe where dictionary keys are column labels
  17. Removing prefix from column names in Pandas
  18. Rename result columns from Pandas aggregation (“FutureWarning: using a dict with renaming is deprecated”)
  19. Pandas groupby.size vs series.value_counts vs collections.Counter with multiple series
  20. Mapping columns from one dataframe to another to create a new column [duplicate]
  21. How to create a dictionary of two pandas DataFrame columns
  22. Unpack dictionary from Pandas Column
  23. How to json_normalize a column with NaNs
  24. Dictionary column in pandas dataframe
  25. How to convert a dataframe to a dictionary
  26. Nested Dictionary to MultiIndex pandas DataFrame (3 level)
  27. Pandas DataFrame performance
  28. DataFrame with MultiIndex to dict
  29. dataframe to dict such that one column is the key and the other is the value [duplicate]
  30. How to convert string representation of dictionary in Pandas DataFrame to a new columns?

Leave a Comment