While analyzing the real datasets which are often very huge in size, we might need to get the column names in order to perform some certain operations.
Let’s discuss how to get column names in Pandas dataframe.
First, let’s create a simple dataframe with nba.csv file.
# Import pandas package import pandas as pd # making data frame # calling head() method # storing in new variable data_top = data.head() # display data_top |
Now let’s try to get the columns name from above dataset.
Method #1: Simply iterating over columns
# Import pandas package import pandas as pd # making data frame data = pd.read_csv("nba.csv") # iterating the columns for col in data.columns: print(col) |
Output:
Method #2: Using columns with dataframe object
# Import pandas package import pandas as pd # making data frame data = pd.read_csv("nba.csv") # list(data) or list(data.columns) |
Output:
Method #3: column.values method returs an array of index.
# Import pandas package import pandas as pd # making data frame data = pd.read_csv("nba.csv") list(data.columns.values) |
Output:
Method #4: Using tolist() method with values with given the list of columns.
# Import pandas package import pandas as pd # making data frame data = pd.read_csv("nba.csv") list(data.columns.values.tolist()) |
Output:
Method #5: Using sorted() method
Sorted() method will return the list of columns sorted in alphabetical order.
# Import pandas package import pandas as pd # making data frame data = pd.read_csv("nba.csv") # using sorted() method sorted(data) |
Output:
Attention geek! Strengthen your foundations with the Python Programming Foundation Course and learn the basics.
To begin with, your interview preparations Enhance your Data Structures concepts with the Python DS Course.
