How to read column name from excel in python
Hello, readers! In this article, we will be focusing on different ways to print column names in Python. So, let us get started! We often come across questions and problem statements wherein we feel the need to deal with data in an excel or
csv file i.e. in the form of rows and columns. Python, as a programming language, provides us with a data structure called ‘DataFrame’ to deal with rows and columns. A Python DataFrame consists of rows and columns and the Pandas module offers us various functions to manipulate and deal with the data occupied within these rows and columns. Today, we will be having a look at the various different ways through which we can fetch and display the column header/names of a dataframe or a csv file. We would be referring the below csv
file in the below examples– 1. Using pandas.dataframe.columns to print column names in PythonWe can use Example: import pandas file = pandas.read_csv("D:/Edwisor_Project - Loan_Defaulter/bank-loan.csv") for col in file.columns: print(col) In this example, we have loaded the csv file into the environment. Further, we have printed the column names through a for loop using dataframe.columns variable. Output: age ed employ address income debtinc creddebt othdebt default 2. Using pandas.dataframe.columns.valuesPython provides us with Syntax: Example: import pandas file = pandas.read_csv("D:/Edwisor_Project - Loan_Defaulter/bank-loan.csv") print(file.columns.values) So, the data.columns.values gives us a list of column names/headers present in the dataframe. Output: ['age' 'ed' 'employ' 'address' 'income' 'debtinc' 'creddebt' 'othdebt' 'default'] 3. Python sorted() method to get the column namesPython Have a look at the below syntax! Syntax: Example: import pandas file = pandas.read_csv("D:/Edwisor_Project - Loan_Defaulter/bank-loan.csv") print(sorted(file)) Output: ['address', 'age', 'creddebt', 'debtinc', 'default', 'ed', 'employ', 'income', 'othdebt'] ConclusionBy this, we have come to the end of this topic. Hope this article turns out to be a hack for you in terms of different solutions for a single problem statement. For more such posts related to Python, Stay tuned and till then, Happy Learning!! 🙂
Keep order of
The following
Tested with Python: 3.5 How do I get column names from Excel in python?3 Easy Ways to Print column Names in Python. Using pandas. dataframe. columns to print column names in Python. ... . Using pandas. dataframe. columns. ... . Python sorted() method to get the column names. Python sorted() method can be used to get the list of column names of a dataframe in an ascending order of columns.. How do I extract a column name in Python?You can get the column names from pandas DataFrame using df. columns. values , and pass this to python list() function to get it as list, once you have the data you can print it using print() statement.
How do I get the column name in pandas Excel?You can get column names in Pandas dataframe using df. columns statement. Usecase: This is useful when you want to show all columns in a dataframe in the output console (E.g. in the jupyter notebook console).
How do I display a column in Python?You can use the loc and iloc functions to access columns in a Pandas DataFrame. Let's see how. If we wanted to access a certain column in our DataFrame, for example the Grades column, we could simply use the loc function and specify the name of the column in order to retrieve it.
|