How to Get Column Names of Pandas DataFrame?

Get DataFrame Column Names

To get the column names of DataFrame, use DataFrame.columns property.

The syntax to use columns property of a DataFrame is

DataFrame.columns

The columns property returns an object of type Index. We could access individual names using any looping technique in Python.

Examples

1. Print DataFrame column names

In this example, we get the dataframe column names and print them.

Python Program

import pandas as pd

# Initialize a DataFrame
df = pd.DataFrame(
	[['Amol', 72, 67, 91],
	['Lini', 78, 69, 87],
	['Kiku', 74, 56, 88],
	['Ajit', 54, 76, 78]],
	columns=['name', 'physics', 'chemistry', 'algebra'])	

# Get the DataFrame column names
cols = df.columns 

# Print the column names
print(cols)
Run Code Copy

Output

Index(['name', 'physics', 'chemistry', 'algebra'], dtype='object')

2. Access individual column names using index

You can access individual column names using the index.

Python Program

import pandas as pd

# Initialize a DataFrame
df = pd.DataFrame(
	[['Amol', 72, 67, 91],
	['Lini', 78, 69, 87],
	['Kiku', 74, 56, 88],
	['Ajit', 54, 76, 78]],
	columns=['name', 'physics', 'chemistry', 'algebra'])	

# Get the DataFrame column names
cols = df.columns 

# Print the column names
for i in range(len(cols)):
	print(cols[i])
Run Code Copy

Output

name
physics
chemistry
algebra

3. Print column names using For loop

You can use a For loop to iterate over the column names of DataFrame.

Python Program

import pandas as pd

# Initialize a dataframe
df = pd.DataFrame(
	[['Amol', 72, 67, 91],
	['Lini', 78, 69, 87],
	['Kiku', 74, 56, 88],
	['Ajit', 54, 76, 78]],
	columns=['name', 'physics', 'chemistry', 'algebra'])	

# Get the DataFrame column names
cols = df.columns 

# Print the column names using For loop
for column in cols:
	print(column)
Run Code Copy

Output

name
physics
chemistry
algebra

Summary

In this Pandas Tutorial, we extracted the column names from DataFrame using DataFrame.column property.

Code copied to clipboard successfully 👍