Changing multiple column names but not all of them – Pandas Python

by

say you have a dictionary of the new column names and the name of the column they should replace:

df.rename(columns={'old_col':'new_col', 'old_col_2':'new_col_2'}, inplace=True)

But, if you don’t have that, and you only have the indices, you can do this:

column_indices = [1,4,5,6]
new_names = ['a','b','c','d']
old_names = df.columns[column_indices]
df.rename(columns=dict(zip(old_names, new_names)), inplace=True)

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. Filter dataframe rows if value in column is in a set list of values [duplicate]
  4. Add missing dates to pandas dataframe
  5. Converting a Pandas GroupBy output from Series to DataFrame
  6. Pandas: sum DataFrame rows for given columns
  7. datetime dtypes in pandas read_csv
  8. Pandas DataFrame: replace all values in a column, based on condition
  9. Pandas – Slice large dataframe into chunks
  10. Calculate average of every x rows in a table and create new table
  11. Removing prefix from column names in Pandas
  12. Python Pandas update a dataframe value from another dataframe
  13. Mapping columns from one dataframe to another to create a new column [duplicate]
  14. Action with pandas SettingWithCopyWarning
  15. python dataframe pandas drop column using int
  16. How to plot two columns of a pandas data frame using points
  17. which is faster for load: pickle or hdf5 in python
  18. How to read a list of parquet files from S3 as a pandas dataframe using pyarrow?
  19. Return multiple columns from pandas apply()
  20. Python Pandas – Merge based on substring in string
  21. Filling in date gaps in MultiIndex Pandas Dataframe
  22. append dictionary to data frame
  23. Find unique values in a Pandas dataframe, irrespective of row or column location
  24. Calculate summary statistics of columns in dataframe
  25. How to use str.contains() with multiple expressions in pandas dataframes
  26. Check if certain value is contained in a dataframe column in pandas [duplicate]
  27. Pandas: Join dataframe with condition
  28. UnicodeDecodeError when reading CSV file in Pandas
  29. How to return a csv file/Pandas DataFrame in JSON format using FastAPI?
  30. how to understand closed and label arguments in pandas resample method?

Leave a Comment