sql rename column name code example

Example 1: rename column pandas

>>> df = pd.DataFrame({"A": [1, 2, 3], "B": [4, 5, 6]})
>>> df.rename(columns={"A": "a", "B": "c"})
   a  c
0  1  4
1  2  5
2  3  6

Example 2: rename df column

import pandas as pd
data = pd.read_csv(file)
data.rename(columns={'original':'new_name'}, inplace=True)

Example 3: rename column name pandas dataframe

df.rename(columns={"old_col1": "new_col1", "old_col2": "new_col2"})

Example 4: python: change column name

df = df.rename(columns = {'myvar':'myvar_new'})

Example 5: pandas dataframe rename column

df = df.rename(columns={'oldName1': 'newName1', 'oldName2': 'newName2'})
# Or rename the existing DataFrame (rather than creating a copy) 
df.rename(columns={'oldName1': 'newName1', 'oldName2': 'newName2'}, inplace=True)

Example 6: cmd to rename a collumn name in sql

ALTER TABLE table_name RENAME COLUMN old_name TO new_name;