Python – Get the datatypes of columns

To get the datatypes of columns, use the info() method. Let us first import the required library −

import pandas as pd

Create a DataFrame with 2 columns having different datatypes −

dataFrame = pd.DataFrame(
   {
      "Student": ['Jack', 'Robin', 'Ted', 'Marc', 'Scarlett', 'Kat', 'John'],"Roll Number": [ 5, 10, 3, 8, 2, 9, 6]
   }
)

Get the complete information about datatypes −

dataFrame.info()

Example

Following is the complete code −

import pandas as pd

# Create DataFrame
dataFrame = pd.DataFrame(
   {
      "Student": ['Jack', 'Robin', 'Ted', 'Marc', 'Scarlett', 'Kat', 'John'],"Roll Number": [ 5, 10, 3, 8, 2, 9, 6]
   }
)

print"DataFrame ...\n",dataFrame

print"\nInfo and the datatypes of the columns in the dataframe:\n"

# get the datatypes info
print(dataFrame.info())

Output

This will produce the following output −

DataFrame ...
   Roll Number   Student
0            5      Jack
1           10     Robin
2            3       Ted
3            8      Marc
4            2  Scarlett
5            9       Kat
6            6      John

Info and the datatypes of the columns in the dataframe:

<class 'pandas.core.frame.DataFrame'>
RangeIndex: 7 entries, 0 to 6
Data columns (total 2 columns):
Roll Number    7  non-null  int64
Student        7  non-null  object
dtypes: int64(1), object(1)
memory usage: 184.0+ bytes
None

AmitDiwan

Updated on: 21-Sep-2021

79 Views

Kickstart Your Career

Get certified by completing the course

Get Started