Learn DataFrame Attributes In Python

Before reading this article, I will suggest you read “DataFrames in Python”. In that article, I have explained about the DataFrames and different ways of creating DataFrames in Python. Now, in this article, I am going to explain all the attributes of a DataFrame.

DataFrame Attributes

All information related to a DataFrame is available in its attributes. Python provides a lot of dataframe attributes to access the information of a dataframe.

Some attributes are mentioned below.

We can access all the information as below.

<DataFrame Object> . <Attribute Name>

Let's understand with an example. For this, first of all, we are creating a DataFrame. For creating a DataFrame, use the below code.

import pandas
dictObj={‘EmpId’:[‘E01’,’E02’,’E03’],
‘EmpName’:[‘Raj,’Ram’,’Renu’],
‘Department’:[‘Accounts’,’HR’,’IT’]
}
df=pandas.DataFrame(dictObj)

We can create a DataFrame having the name df. To get all the information related to that data frame, we use dataframe attributes. Now, let’s go through all the dataframe attributes.

Get information related to Index, Columns, Axes and Data Types

index

Returns the starting value, ending value, and the difference(step) of row index.

df.index
## Output is RangeIndex(start=0,stop=3,step=1)

columns

Returns the column name of the dataframe.

df.columns
## Output : Index([‘EmpId’,’EmpName,’Department’],dtype=’object’)

axes

Returns a list which contains the rowindex as well as the column name of the dataframe.

df.axes
## Output : [RangeIndex(start=0,stop=3,step=1), Index([‘EmpId’,’EmpName,’Department’],dtype=’object’)]

dtypes

Returns datatypes of each column of a dataframe.

df.dtypes
## Output :
## EmpId Object
## EmpName Object
## Department Object
## dtype : Object

See the output of all the above attributes in running mode,

Retrieving size (no. of elements), shape, number of dimensions

size

Returns a total number of elements present in dataframe.

df.size
## Output 12

shape

Returns a tuple which gives the present number of rows and number of columns of a dataframe as an element.

df.shape
##Output : (3,3)

ndim

Returns an integer value which represents the number of dimensions of a dataframe.

df.ndim
## Output : 2

See the output of all the above attributes in running mode.

Retrieving values

values

Returns a NumPy array which contains all rows as a value.

df.values

Checking for emptiness

empty

Returns a Boolean value which represents if the dataframe is empty or not. If it will return “True”, then dataframe is empty, otherwise, it is not empty.

df.empty
##Output : False

Transposing a DataFrame

It transposes a dataframe, i.e., rows become columns and columns become rows.

df.T

Getting Count of non-NA values in dataframe

count()

It will return non-NA values for each COLUMNS. By default, it will take 0 as an argument.

df.count()
## Output :
## EmpId 3
## EmpName 3
## Department 3

count(1)

If we pass 1 as an argument, then instead of returning number of columns, it will return number of each rows along with index number,

df.count(1)
## Output
## 0 3
## 1 3
## 2 3

Count with axis parameter

We can also explicitly specify an argument to count() as axis.

If we want to count columns value then pass argument like

df.count(axis=’columns’)

If we want to count rows value then pass argument like

df.count(axix=’rows’)

See the output of all the above count attribute in running mode,

CONCLUSION

Now, we have learned about the DataFrames attributes in Python and how we can easily access any information of DataFrame.

All the queries related to this article and sample files are always welcome. Thanks for reading.!!!