Description. (In database terms this looks a lot like a variation of a controlled coalesce.). I hate spam & you may opt out anytime: Privacy Policy. 2) but to remove a column by name in R, you can also use dplyr, and you’d just type: select(Your_Dataframe, -X). For example delete columns at index position 0 & 1 from dataframe object dfObj i.e. To drop columns by index position, we first need to find out column names from index position and then pass list of column names to drop(). I want to get the column index in which a given value is found. “X”) to the index of the column: select(Your_DF -1) . When and how to use the Keras Functional API, Moving on as Head of Solutions and AI at Draper and Dash. You can access the column names using index. yes but how? It is essentially the same trick as the data.table solution: break the problem into groups where the choice is not varying (allowing us to use scalar column specifiers to do the work). Example 1: Print DataFrame Column Names. It works like this: Also, rquery can perform this operation on database tables! If `row` is a 2-d array, this should not be given. Let’s discuss how to get row names in Pandas dataframe . Method #1: Changing the column name and row index using df.columns and df.index attribute. Python Program What we are doing is grouping by “choice”. I’m Joachim Schork. Also, the “[[1]]” is converting the column of choice values (all of which are the same due to the grouping by choice) into a scalar. data) Then, we need to open some square brackets (i.e. © Copyright Statistics Globe – Legal Notice & Privacy Policy, Example 1: Extract Column Index of Variable with Exact Match, Example 2: Extract Column Indices of Variables with Partial Match. Try col=max.col(data) This should give you the index of the column with the max value. getting column's name. It is the basic object storing axis labels. We can get the ndarray of column names from this Index object i.e. Your email address will not be published. DataFrame.columns. Python Program Drop Columns by Index Position in DataFrame. subset = dfObj.loc[ 'a' : 'c' ,'Age' : 'City' ] It will return a subset DataFrame with rows from a to c & columns from Age to City i.e. # 1. In this tutorial, I’ll illustrate how to find the index of a column in a data frame in the R programming language. It can be also used to remove columns from the data frame. In addition, you may want to read the related tutorials of my homepage: At this point you should have learned how to identify the variable index based on its label in a data frame in the R programming language. The column of interest can be specified either by name or by index. Please read on for some idiomatic base R, data.table, and dplyr solutions. Example 2 explains how to search for columns partially matching a character string using the grep and colnames functions: grep("x1", colnames(data)) # Apply grep function Get DataFrame Column Names. ... To retrieve a data frame slice with the two columns mpg and hp, we pack the column names in an index vector inside the single square bracket operator. We have wrapped base-R and data.table implementations into method a in rquery/rqdatatable here. Let’s examine how to sort the contents of a data frame by the value of a column > numPeople = 10 > sex=sample(c("male","female"),numPeople,replace=T) > age = sample(14:102, numPeople, replace=T) > income = sample(20:150, numPeople, replace=T) > minor = age. Required fields are marked *. Note, in that example, you removed multiple columns (i.e. This TechVidvan article is designed to help you in creating, accessing, and modifying data frame in R. Data frames are lists that have a class of “data frame”.They are a special case of lists where all the components are of equal length.. 18 . Hello. To drop columns by index position, we first need to find out column names from index position and then pass list of column names to drop(). This post describes the following contents with sample code. require(["mojo/signup-forms/Loader"], function(L) { L.start({"baseUrl":"mc.us18.list-manage.com","uuid":"e21bd5d10aa2be474db535a7b","lid":"841e4c86f0"}) }), Your email address will not be published. In base-R we can use a matrix-index to specify the set of data cells we want (please see “help([)” for details): data.table has some known notation and solutions for this (please see “help(.SD)” for details): What we are doing is grouping by “choice”. Rows to subset by. columns do not get associated names exactly like that. In each group the choice column is a constant, and data.table supplies the name of the group as a scalar in the variable named choice. You’re here for the answer, so let’s get straight to the examples…, data <- data.frame(x1 = 1:3, # Example data Posted on September 20, 2018 by John Mount in R bloggers | 0 Comments. Get Column Names from a DataFrame object. The previous R syntax can be explained as follows: First, we need to specify the name of our data set (i.e. For a data frame, rownames and colnames eventually call row.names and names respectively, but the latter are preferred. D&D’s Data Science Platform (DSP) – making healthcare analytics easier, High School Swimming State-Off Tournament Championship California (1) vs. Texas (2), Learning Data Science with RStudio Cloud: A Student’s Perspective, Risk Scoring in Digital Contact Tracing Apps, Junior Data Scientist / Quantitative economist, Data Scientist – CGIAR Excellence in Agronomy (Ref No: DDG-R4D/DS/1/CG/EA/06/20), Data Analytics Auditor, Future of Audit Lead @ London or Newcastle, python-bloggers.com (python/data-science news), Python Musings #4: Why you shouldn’t use Google Forms for getting Data- Simulating Spam Attacks with Selenium, Building a Chatbot with Google DialogFlow, LanguageTool: Grammar and Spell Checker in Python, Click here to close (This popup will not appear again). Get regular updates on the latest tutorials, offers & news at Statistics Globe. In each group the choice column is a constant, and data.table supplies the name of the group as a scalar in the variable named choice. Pandas returns the names of columns as Pandas Index object. # 1 1 a 5 Let’s see how to calculate Maximum value in R … # 2 2 b 5 We’ll also show how to remove columns from a data frame. 8.4 Dataframe column names. var index = table.columns().names().indexOf( 'Salary' ); // Note that this could also be done using `column().index()` and a name selector Related The following options are directly related and may also be useful in your application development. Table of contents: All you just need to do is to mention the column index number. In this example, we get the dataframe column names and print them. Let’s install and load data.table to RStudio: This post describes the following contents with sample code. Get the column index of the selected column. The previous R syntax can be explained as follows: First, we need to specify the name of our data set (i.e. This lets us assign values from that column all at once (.SD, being data.table’s notation for the sub-data.table representing the group). In this Pandas tutorial, we will learn 6 methods to get the column names from Pandas dataframe.One of the nice things about Pandas dataframes is that each column will have a name (i.e., the variables in the dataset). DataTables stores the data for rows and columns in internal indexes for fast ordering, searching etc. x2 = letters[1:3], One of the nice things about dataframes is that each column will have a name. What is going on: is we are reducing the choice column to a series of scalars- so we can then use the scalar column selection operators (such as “[[]]”) to access columns. so can not use table.column.columnname. Instead of passing all the names in index or column list we can pass range also i.e. which(colnames(data) == "x1") # Apply which function $ is not valid as part of the data set (or frame) name since R uses it to denote column name (:)) so R actually tried to get the column name 'data' from the data frame named 'model' Try: Select Data Frame Column Using Character Vector, Return Column Name of Largest Value for Each Row, Find Index of Maximum & Minimum Value of Vector & Data Frame Row, Print Entire tibble to R Console (2 Examples), Find Common Elements from Multiple Vectors in R (Example), Add and Subtract Days to from Date in R (2 Examples), Return Value from R Function (3 Examples). You will learn how to use the following functions: pull(): Extract column values as a vector. Please let me know in the comments section, in case you have additional questions. To change all the column names of an R Dataframe, use colnames () as shown in the following syntax colnames (mydataframe) = vector_with_new _names []) Within these brackets, we need to write a comma to reflect the two dimensions of our data. Column names of an R Dataframe can be acessed using the function colnames().You can also access the individual column names using an index to the output of colnames() just like an array.. To change all the column names of an R Dataframe, use colnames() as shown in the following syntax We recently saw a great recurring R question: “how do you use one column to choose a different value for each row?” That is: how do you use a column as an index? While analyzing the real datasets which are often very huge in size, we might need to get the rows or index names in order to perform some certain operations. However, having the column names as a list is useful in many situation. Our DataFrame object dfObj is, Maximum of single column in R, Maximum of multiple columns in R using dplyr. The minus sign is to drop variables. To access the names of a dataframe, use the function names(). The extractor functions try to do something sensible for any matrix-like object x.If the object has dimnames the first component is used as the row names, and the second component (if any) is used for the column names. Column names of an R Dataframe can be acessed using the function colnames (). Note that the rownames_to_column command adds the row_names column at the first index position of our data frame (in contrast to our R syntax of Example 1). To access the names of a dataframe, use the function names(). Note that the rownames_to_column command adds the row_names column at the first index position of our data frame (in contrast to our R syntax of Example 1). What we are doing is grouping by “choice”. R – Risk and Compliance Survey: we need your help! Another popular R package for data manipulation is the data.table package. This lets us assign values from that column all at once (.SD, being data.table’s notation for the sub-data.table representing the group). # Get ndArray of all column names. While in most part they column index will be the order the columns created, but they can change if you delete or insert columns. It returns an object. Get the column index of the selected column. As you can see based on Table 2, the previous R syntax extracted the columns x1 and x3. just to add another possibility: You can usually use grep and it's decedents (i.e., grepl, to do these kind of jobs in a more sophisiticated way using regular expressions.. On your example your could get the column index with: grep("^bar$", colnames(x)) or grep("^bar$", names(x)) The ^ and $ are meta characters for the beginning and end of a string, respectively. Nearest equivalent would be getting column index with HeaderText, and then using that index. Copyright © 2020 | MH Corporate basic by MH Themes, rquery can perform this operation on database tables, Click here if you're looking to post or find an R/data-science job, Introducing our new book, Tidy Modeling with R, How to Explore Data: {DataExplorer} Package, R – Sorting a data frame by the contents of a column, Whose dream is this? Suppose our goal is to build a new column called “derived” that for each row chooses from the column named by the names in the column called “choice”. It returns an object. Select Rows & Columns by Name or Index in Pandas DataFrame using [ ], loc & iloc; How to get column names in Pandas dataframe; Decimal Functions in Python | Set 2 (logical_and(), normalize(), quantize(), rotate() … ) NetworkX : Python software package for study of complex networks; Directed Graphs, Multigraphs and Visualization in Networkx select(): Extract one or multiple columns as a data table. You can access the column names using index. columnsNamesArr = dfObj.columns.values. Let us first load Pandas. Select Rows & Columns by Name or Index in Pandas DataFrame using [ ], loc & iloc; How to get column names in Pandas dataframe; Decimal Functions in Python | Set 2 (logical_and(), normalize(), quantize(), rotate() … ) NetworkX : Python software package for study of complex networks; Directed Graphs, Multigraphs and Visualization in Networkx For example delete columns at index position 0 & 1 from dataframe object dfObj i.e. df <- mydata[ -c(1,3:4) ] On this website, I provide statistics tutorials as well as codes in R programming and Python. Extract first n characters of the column in R Method 1: In the below example we have used substr() function to find first n characters of the column in R. substr() function takes column name, starting position and length of the strings as argument, which will return the substring of the specific column … The same methods can be used to rename the label of pandas.Series.. To get the list of column names of dataframe in R we use functions like names() and colnames(). As you can see based on the previous output of the RStudio console, our example data contains three rows and the three columns x1, x2, and x12. The same methods can be used to rename the label of pandas.Series.. For a data frame, rownames and colnames eventually call row.names and names respectively, but the latter are preferred. Table of contents: You can access the column names of DataFrame using columns property. Get DataFrame Column Names. Get Column Index in Data Frame by Variable Name in R (2 Examples) In this tutorial, I’ll illustrate how to find the index of a column in a data frame in the R programming language. DataTables stores the data for rows and columns in internal indexes for fast ordering, searching etc. var index = table.columns().names().indexOf( 'Salary' ); // Note that this could also be done using `column().index()` and a name selector Related The following options are directly related and may also be useful in your application development. Description. the variable with the variable name “x1” is at the first index position of our data frame. We will use Pandas coliumns function get the names of the columns. It can be useful at times to know what these indexes are, as they can be used for efficient selectors in the row(), column() and other API methods which use selectors. In this post we will see how to get the column names as a list. Hi, I 'd like to know how to retrieve a column name of a data frame. I hate spam & you may opt out anytime: Privacy Policy. Age City a 34 Sydeny b 30 Delhi c 16 New York DataFrame.iloc | Select Column Indexes & Rows Index … In the following code, we are telling R to drop variables that are positioned at first column, third and fourth columns. Example 3: Convert Row Names to Column with data.table Package. Note that the character string “x1” (partially) matches two columns (i.e. []) Within these brackets, we need to write a comma to reflect the two dimensions of our data. In this tutorial we will be looking on how to get the list of column names in the dataframe with an example. This means, when we define the first three columns of the pres_results data frame, year, state and total_votes, dplyr converts these names to the index values 1, 2 and 3. However, having the column names as a list is useful in many situation. You may use the following approach in order to set a single column as the index in the DataFrame: df.set_index('column') For example, let’s say that you’d like to set the ‘Product‘ column as the index. When we use the select() function and define the columns we want to keep, dplyr does not actually use the name of the columns but the index of the columns in the data frame. Solution. Indexing with numbers and names… It is the basic object storing axis labels. In this Section, I’ll explain how to identify variables with a complete match to a character string. Do you need more explanations on the R programming codes of this article? In this R tutorial, we will take a look at R data frames. Next, you’ll see how to change that default index. In many of the examples, below, there are multiple ways of doing the same thing. An R tutorial on retrieving a collection of column vectors in a data frame with the single square operator. # x1 x2 x12 This will return a string vector with the names of the dataframe. It can be useful at times to know what these indexes are, as they can be used for efficient selectors in the row(), column() and other API methods which use selectors. You can also access the individual column names using an index to the output of colnames () just like an array. I'd do it so that I'd use TemplateField's with Literals or Labels, and use FindControl to locate them on specific row, so that column … Let’s discuss how to get row names in Pandas dataframe . Let’s install and load data.table to RStudio: These may be numeric indices, character names, a logical mask, or a 2-d logical array col The columns to index by. Maximum value of a column in R can be calculated by using max() function.Max() Function takes column name as argument and calculates the maximum value of that column. # 1 3. This is because a data.frame is a special kind of list and not a special kind of matrix. You can change index / columns names (labels) of pandas.DataFrame by using rename(), add_prefix(), and add_suffix() or updating the index / columns attributes.. This approach also works for a matrix. Method #1: Changing the column name and row index using df.columns and df.index attribute. DataFrame object has an Attribute columns that is basically an Index object and contains column Labels of Dataframe. You can use these name to access specific columns by name without having to know which column number it is. In this Pandas tutorial, we will learn 6 methods to get the column names from Pandas dataframe.One of the nice things about Pandas dataframes is that each column will have a name (i.e., the variables in the dataset). The extractor functions try to do something sensible for any matrix-like object x.If the object has dimnames the first component is used as the row names, and the second component (if any) is used for the column names. Renaming the column names/variable names can be done in multiple ways in R. However, this post will enable analyst to identify index numbers of rows and columns. In each group the choice column is a constant, and data.table supplies the name of the group as a scalar in the variable named choice. Example 1: Print DataFrame Column Names. You can usually use grep and it's decedents (i.e., grepl, to do these kind of jobs in a more sophisiticated way using regular expressions. Get Column Index in Data Frame by Variable Name in R (2 Examples) In this tutorial, I’ll illustrate how to find the index of a column in a data frame in the R programming language. lw@zi 9-Aug-12 4:20am The object "col" in … Renaming the column names/variable names can be done in multiple ways in R. However, this post will enable analyst to identify index numbers of rows and columns. If ‘:’ is given in rows or column Index Range then all entries will be included for corresponding row or column. In this example, we get the dataframe column names and print them. 8.4 Dataframe column names. Some discussion of the ideas can be found here. This lets us assign values from that column all at once (.SD, being data.table’s notation for the sub-data.table representing the group). You can access the column names of DataFrame using columns property. Get regular updates on the latest tutorials, offers & news at Statistics Globe. This last statement might look surprising if you’re used to Java or a traditional programming language. When we use the select() function and define the columns we want to keep, dplyr does not actually use the name of the columns but the index of the columns in the data frame. Of course you can query the indexes, but they don't mean much. Step 2: Set a single column as Index in Pandas DataFrame. value Provide a an empty vector of some type to specify the type of the output. data # Print example data It's easier to remove variables by their position number. We will use Pandas coliumns function get the names of the columns. Then you may have a look at the following video of my YouTube channel. You can also use the column name to get values. Note that whereas [2] would be the second element in a matrix, it refers to the second column in a data.frame. Of course you can query the indexes, but they don't mean much. # rename column in r dplyr rename (new_field_name = old_field_name) You were previously able to directly use column index references in this package. Elements from a vector, matrix, or data frame can be extracted using numeric indexing, or by using a boolean vector of the appropriate length. Finally, if you want to delete a column by index, with dplyr and select, you change the name (e.g. Learn r how to create data frame with column names reskilling it reshape wide data frame to long format in r using column name r sort columns of a data frame by vector column names stack data frame in r. Whats people lookup in this blog: R Data Frame Get Column Names; R Dataframe Select Column Names; R Data Frame Get Column Name By Index On your example your could get the column index with: grep ("^bar$", colnames (x)) or grep ("^bar$", names (x)) The ^ and $ are meta characters for the beginning and end of a string, respectively. In this tutorial, we will learn how to change column name of R Dataframe. Subscribe to my free statistics newsletter. You want to get part of a data structure. This means, when we define the first three columns of the pres_results data frame, year, state and total_votes, dplyr converts these names to the index values 1, 2 and 3. $ is not valid as part of the data set (or frame) name since R uses it to denote column name (:)) so R actually tried to get the column name 'data' from the data frame named 'model' Try: i want to find column in datarow not in table. These are some ideas that will eventually be expanded and make it into our theory of coordinatized data (please also see here) and Practical Data Science in R 2nd Edition. We call this trick a “pseudo aggregator”, and we often teach the technique in SQL (where it is often min() or max()). In our case the result would be “[1, 6, 3, NA]” (the last value being “NA” as “z” is not a column of df). # 3 3 c 5. Columns Age & Name deleted . R Data Frame Get Column Name By Index viewframes June 2, 2019 Uncategorized No Comments Selecting multiple columns with loc can be achieved by passing column names to the second argument of note that the first example returns a series and second dataframe you can achieve single column by select columns of a data frame in r last name set as index on sample data frame Details. Let’s first create the dataframe. Let’s see how to use it. get column index with match using apply Hi everyone, This is probably something very simple but I have just not been able to figure it out and wonder if perhaps you may know. data) Then, we need to open some square brackets (i.e. As you can see based on Table 2, the previous R syntax extracted the columns x1 and x3. In this post we will see how to get the column names as a list. Drop Columns by Index Position in DataFrame. The RStudio console returns the value 1, i.e. Following contents with sample code of some type to specify the name of a controlled.. Step 2: set a single column r get column name by index index in which a given value is found 1 and,... Of an R dataframe can be found here on conditions look at the following contents with sample code interest. At first column, third and fourth columns use for the database to variables! Of dataframe using columns property the name ( e.g may be numeric indices, character names, a logical,! May opt out anytime: Privacy Policy RStudio: the column-index is for internal use for database. See based on Table 2, the previous R syntax extracted the columns based on conditions ( i.e to. Index position contain the character pattern “ x1 ” ( partially ) matches columns. Nearest equivalent would be the second element in a matrix, it refers the. Names in the following functions: pull ( ) function which select the columns based on 2. And Dash individual column names of a dataframe, use the function names ( ) like. These brackets, we need to use the following code, we to. With an example numeric indices, character names, a logical mask, or a 2-d array. Is for internal use for the database can pass Range also i.e discussion of the.. Youtube channel be the second column in datarow not in Table index function to work col '' in … column. Example 3: Convert row names to access the column: select ( Your_DF -1 ) (. Query the indexes, but they do n't mean r get column name by index an array vectors in data.frame! And df.index attribute spam & you may have a look at R frames. Is that each column will have a name be numeric indices, names!, Moving on as Head of solutions and AI at Draper and.! R, Maximum of multiple columns as Pandas index object and contains column Labels of dataframe using property... ’ s discuss how to remove columns from a data Table ( in database terms looks... Function which select the columns write a comma to reflect the two dimensions of our data frame with max... Anytime: Privacy Policy single square operator rownames and colnames eventually call row.names and respectively. Api, Moving r get column name by index as Head of solutions and AI at Draper Dash... Code of this tutorial we will use Pandas coliumns function get the column names as a data frame, and... This Section, I illustrate the R programming codes of this tutorial and colnames call... Contents with sample code Head of solutions and AI at Draper and Dash, rquery perform. Based on Table 2, the previous R syntax can be explained as follows first... This last statement might look surprising if you ’ ll explain how to get the names of an tutorial... Be explained as follows: first, we can pass Range also i.e controlled coalesce. ) the of! For data manipulation is the data.table package Python Program you want to find column in datarow in., rquery can perform this operation on database r get column name by index matches two columns ( i.e dfObj,... Logical mask, or a traditional programming language like a variation of a,... Having the column name to access specific columns by name without having to know which column it. Value in R programming codes of this article variables by their position number you index... -1 ): Convert row names to access specific columns by name or by index function to.! Do you need to specify the name ( e.g variable with the more recent releases, you ’ see... Using df.columns and df.index attribute codes in R … Details following contents sample! Range then all entries will be included for corresponding row or column list we can pass Range also.. Data.Table implementations into method a in rquery/rqdatatable here syntax can be acessed using the names... ` row ` is a special kind of matrix function colnames ( data ) then, we get dataframe... The variable name “ x1 ” ( partially ) matches two columns (.... Programming language implementations into method a in rquery/rqdatatable here of single column a! Is the data.table package multiple ways of doing the same methods can be explained follows! 1,3:4 ) ] get dataframe column names tutorials as well as codes in R … Details ’ is given rows! This example, we need to open some square brackets ( i.e position 0 & 1 dataframe. Get the column of interest can be explained as follows: first, we will take a at... Columns by name without having to know which column number it is specific columns by without... From the data for rows and columns in internal indexes for fast ordering, searching etc a an empty of! Delete columns at index position 0 & 1 from dataframe object dfObj,! For example delete columns at index position 0 & 1 from dataframe dfObj! Dfobj is, note, in that example, you need to use function! ): Extract column values as a list index in which a given value is found with single! Is a 2-d array, this should give you the index of the examples, below, are. In a data.frame names in Pandas dataframe are r get column name by index ) just like an array vectors in a.... Note that the character string “ x1 ” also access the names of the nice things about dataframes that. Column by index, with dplyr and select, you ’ ll how! Also i.e and Python names exactly like that this website, I provide Statistics tutorials as well as codes R... Function which select the columns x1 and x3 empty vector of some type to specify name. With dplyr and select, you change the name of our data frame get associated names exactly that! A vector might look surprising if you ’ re used to remove from... Database tables == `` x1 '' ) # Apply which function # 1 Changing... An empty vector of some type to specify the type of the output of colnames ( ) which... Dfobj i.e data.frame is a special kind of matrix have a look at R data frames we are is. To index by then all entries will be included for corresponding row or column:... One or multiple columns in R is provided with select ( Your_DF -1 ) (... From the data frame, rownames and colnames eventually call row.names and names respectively but. Names exactly like that data.frame is a special kind of list and not a kind! On the latest tutorials, offers & news at Statistics Globe retrieve a column name and row index using and! The ndarray of column names as a list API, Moving on as of. Get the column names as a data Table will take a look at data. This post we will see how to remove variables by their position number extra to... Dataframe object dfObj i.e and Python 4:20am the object `` col '' in … getting column 's.... 0 comments website, I ’ ll also show how to identify variables with complete... Index to the output of colnames ( ) function which select the columns x1 and x3 R provided!, rownames and colnames eventually call row.names and names respectively, but the latter are preferred and respectively. Get the dplyr rename column by index function to work datatables stores data. A list ( Your_DF -1 ) programming and Python example delete columns index. ” ( partially ) matches two columns ( i.e may opt out anytime: Privacy Policy third index of... Interest can be specified either by name without having to know which column number it is ]... How to identify variables with a complete match to a character string Convert row names Pandas. May have a look at the first index position 0 & 1 from object. Let ’ s see how to change that default index having the column with the max value, a mask! ( in database terms this looks a lot like a variation of a dataframe use. Values as r get column name by index list is useful in many of the output of colnames ( )... Not a special kind of matrix are preferred data Table, in example... At Draper and Dash the same methods can be acessed using the function (! However, having the column names in the dataframe column names of a dataframe, the! The label of pandas.Series method # 1: Changing the column of interest can be found.! Pandas coliumns function get the dplyr rename column by index, with dplyr and select you... Set a single column in a data frame mydata [ -c ( )! With HeaderText, and dplyr solutions know how to identify variables with a complete match to a character string x1... Column index in Pandas dataframe of our data set ( i.e ” ) to the of! In a data frame, rownames and colnames eventually call row.names and names respectively, but do... Type to specify the name of our data be acessed using the function names ( ) of this?! Of columns as Pandas index object row.names and names respectively, but they do n't mean....: the column-index is for internal use for the database object dfObj i.e surprising if you ll. Now, we can use these names to column with the names of the output pattern... R syntax can be explained as follows: first, we get the names of the dataframe column names print.