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.
DataFrame Attributes by Mahesh Verma
We can access all the information as below.
  1. <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.
  1. import pandas
  2. dictObj={‘EmpId’:[‘E01’,’E02’,’E03’],
  3. ‘EmpName’:[‘Raj,’Ram’,’Renu’],
  4. ‘Department’:[‘Accounts’,’HR’,’IT’]
  5. }
  6. 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.
  1. df.index
  2. ## Output is RangeIndex(start=0,stop=3,step=1)
columns

Returns the column name of the dataframe.
  1. df.columns
  2. ## Output : Index([‘EmpId’,’EmpName,’Department’],dtype=’object’)
axes
Returns a list which contains the rowindex as well as the column name of the dataframe.
  1. df.axes
  2. ## Output : [RangeIndex(start=0,stop=3,step=1), Index([‘EmpId’,’EmpName,’Department’],dtype=’object’)]
dtypes
Returns datatypes of each column of a dataframe.
  1. df.dtypes
  3. ## Output :
  4. ## EmpId Object
  5. ## EmpName Object
  6. ## Department Object
  7. ## dtype : Object
See the output of all the above attributes in running mode,
index, columns, dtypes in DataFrame

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

size
Returns a total number of elements present in dataframe.
  1. df.size
  2. ## Output 12
shape
Returns a tuple which gives the present number of rows and number of columns of a dataframe as an element.
  1. df.shape
  2. ##Output : (3,3)
ndim
Returns an integer value which represents the number of dimensions of a dataframe.
  1. df.ndim
  2. ## Output : 2
See the output of all the above attributes in running mode.

size, shape, ndim in DataFrame

Retrieving values

values
Returns a NumPy array which contains all rows as a value.
  1. df.values
values in dataframe

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.
  1. df.empty
  2. ##Output : False
empty dataframe

Transposing a DataFrame

T
It transposes a dataframe, i.e., rows become columns and columns become rows.
  1. df.T
transposing a dataframe

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.
  1. df.count()
  2. ## Output :
  3. ## EmpId 3
  4. ## EmpName 3
  5. ## 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,
  1. df.count(1)
  2. ## Output
  3. ## 0 3
  4. ## 1 3
  5. ## 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
  1. df.count(axis=’columns’)
If we want to count rows value then pass argument like
  1. df.count(axix=’rows’)
See the output of all the above count attribute in running mode,
count function in DataFrame

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.!!!