{"id":10429,"date":"2020-11-17T18:47:00","date_gmt":"2020-11-17T18:47:00","guid":{"rendered":"https:\/\/www.askpython.com\/?p=10429"},"modified":"2020-11-17T18:47:01","modified_gmt":"2020-11-17T18:47:01","slug":"print-column-names-in-python","status":"publish","type":"post","link":"https:\/\/www.askpython.com\/python-modules\/pandas\/print-column-names-in-python","title":{"rendered":"3 Easy Ways to Print column Names in Python"},"content":{"rendered":"\n

Hello, readers! In this article, we will be focusing on different ways to print column names<\/strong> in Python.<\/p>\n\n\n\n

So, let us get started!<\/p>\n\n\n\n

\n\n\n\n

First, where do you find columns in Python?<\/h2>\n\n\n\n

We often come across questions and problem statements wherein we feel the need to deal with data in an excel <\/strong>or csv <\/strong>file i.e. in the form of rows and columns.<\/p>\n\n\n\n

Python<\/a>, as a programming language, provides us with a data structure called ‘DataFrame’ to deal with rows and columns.<\/p>\n\n\n\n

A Python DataFrame<\/a><\/strong> consists of rows and columns and the Pandas module<\/a> offers us various functions to manipulate and deal with the data occupied within these rows and columns.<\/p>\n\n\n\n

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.<\/p>\n\n\n\n

We would be referring the below csv file in the below examples–<\/p>\n\n\n\n

\"Dataset-Bank
Dataset-Bank Loan<\/strong><\/figcaption><\/figure><\/div>\n\n\n\n
\n\n\n\n

1. Using pandas.dataframe.columns to print column names in Python<\/h2>\n\n\n\n

We can use pandas.dataframe.columns<\/code> variable to print the column tags or headers at ease. Have a look at the below syntax!<\/p>\n\n\n

\ndata.columns\n<\/pre><\/div>\n\n\n
Example:<\/strong><\/p>\n\n\n
\nimport pandas\n\nfile = pandas.read_csv("D:\/Edwisor_Project - Loan_Defaulter\/bank-loan.csv")\nfor col in file.columns:\n    print(col)\n<\/pre><\/div>\n\n\n
In this example, we have loaded the csv file<\/a> into the environment. Further, we have printed the column names through a for loop using dataframe.columns variable.<\/p>\n\n\n\n
Output:<\/strong><\/p>\n\n\n
\nage\ned\nemploy\naddress\nincome\ndebtinc\ncreddebt\nothdebt\ndefault\n<\/pre><\/div>\n\n\n
\n\n\n\n
2. Using pandas.dataframe.columns.values<\/h2>\n\n\n\n
Python provides us with pandas.dataframe.columns.values<\/code> to extract the column names from the dataframe or csv file and print them.<\/p>\n\n\n\n
Syntax<\/strong>:<\/p>\n\n\n
\ndata.columns.values\n<\/pre><\/div>\n\n\n
Example:<\/strong><\/p>\n\n\n
\nimport pandas\n\nfile = pandas.read_csv("D:\/Edwisor_Project - Loan_Defaulter\/bank-loan.csv")\nprint(file.columns.values)\n<\/pre><\/div>\n\n\n
So, the data.columns.values gives us a list<\/a> of column names\/headers present in the dataframe.<\/p>\n\n\n\n
Output:<\/strong><\/p>\n\n\n
\n['age' 'ed' 'employ' 'address' 'income' 'debtinc' 'creddebt' 'othdebt' 'default']\n<\/pre><\/div>\n\n\n
\n\n\n\n
3. Python sorted() method to get the column names<\/h2>\n\n\n\n
Python sorted()<\/code> method can be used to get the list of  column names of a dataframe in an ascending<\/strong> order <\/strong>of columns.<\/p>\n\n\n\n
Have a look at the below syntax!<\/p>\n\n\n\n
Syntax:<\/strong><\/p>\n\n\n
\nsorted(dataframe)\n<\/pre><\/div>\n\n\n
Example:<\/strong><\/p>\n\n\n
\nimport pandas\n\nfile = pandas.read_csv("D:\/Edwisor_Project - Loan_Defaulter\/bank-loan.csv")\nprint(sorted(file))\n<\/pre><\/div>\n\n\n
Output:<\/strong><\/p>\n\n\n
\n['address', 'age', 'creddebt', 'debtinc', 'default', 'ed', 'employ', 'income', 'othdebt']\n<\/pre><\/div>\n\n\n
\n\n\n\n
Conclusion<\/h2>\n\n\n\n
By 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.<\/p>\n\n\n\n
For more such posts related to Python, Stay tuned and till then, Happy Learning!! \ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":"
Hello, readers! In this article, we will be focusing on different ways to print column names in Python. So, let us get started! First, where do you find columns in Python? 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. […]<\/p>\n","protected":false},"author":4,"featured_media":10453,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[94],"tags":[],"class_list":["post-10429","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-pandas"],"blocksy_meta":[],"_links":{"self":[{"href":"https:\/\/www.askpython.com\/wp-json\/wp\/v2\/posts\/10429","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.askpython.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.askpython.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.askpython.com\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.askpython.com\/wp-json\/wp\/v2\/comments?post=10429"}],"version-history":[{"count":0,"href":"https:\/\/www.askpython.com\/wp-json\/wp\/v2\/posts\/10429\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.askpython.com\/wp-json\/wp\/v2\/media\/10453"}],"wp:attachment":[{"href":"https:\/\/www.askpython.com\/wp-json\/wp\/v2\/media?parent=10429"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.askpython.com\/wp-json\/wp\/v2\/categories?post=10429"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.askpython.com\/wp-json\/wp\/v2\/tags?post=10429"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}