Renaming column names in Pandas

Renaming column names in Pandas is a common task when working with data, and there are several ways to achieve this, depending on your needs.

 Using rename() Method

The rename() method is the most flexible way to rename columns, especially when you only want to rename specific ones:

import pandas as pd
df = pd.DataFrame({
    'old_name': [1, 2, 3],
    'another_old_name': [4, 5, 6]
})
df = df.rename(columns={'old_name': 'new_name', 'another_old_name': 'another_new_name'})
print(df)

• The rename() method allows you to specify which columns to rename using a dictionary.
  
• You can use inplace=True to modify the DataFrame directly without needing to reassign it.
  

 Renaming All Columns at Once

If you want to rename all columns, you can assign a list of new column names directly:

df.columns = ['new_name', 'another_new_name']
print(df)

This method is simpler when you need to rename all columns, but make sure the list length matches the number of columns.

 Using List Comprehensions

For more complex renaming scenarios, like adding a prefix or suffix to all columns, you can use list comprehensions:

df.columns = [col + '_new' for col in df.columns]
print(df)

This method is useful for automating changes like appending prefixes or suffixes.

 Summary:

• Use rename() for selective renaming with flexibility.
  
• Assign a list to df.columns for renaming all columns at once.
  
• Leverage list comprehensions for batch renaming (e.g., adding prefixes).
  

Renaming columns in Pandas is easy and can be tailored to your specific needs, whether you're working with a few columns or modifying an entire dataset!