Pandas Excel: Get the data types of the given excel data fields

Last update on May 03 2025 13:06:28 (UTC/GMT +8 hours)

2. Get Data Types of Excel Data

Write a Pandas program to get the data types of the given excel data (coalpublic2013.xlsx ) fields. Go to Excel data

Sample Solution:

Python Code :

import pandas as pd
import numpy as np
df = pd.read_excel('E:\coalpublic2013.xlsx')    
df.dtypes

Sample Output:

Year            int64
MSHA ID         int64
Mine_Name      object
Production      int64
Labor_Hours     int64
dtype: object

Excel Data:

coalpublic2013.xlsx:

For more Practice: Solve these Related Problems:

Write a Pandas program to import coalpublic2013.xlsx and then display the data types of each column.
Write a Pandas program to load an Excel file and generate a summary of column data types using the dtypes attribute.
Write a Pandas program to import coalpublic2013.xlsx and use the info() method to confirm the data types of all fields.
Write a Pandas program to read coalpublic2013.xlsx and then print the type of each column along with its unique value counts.

Go to:

Previous: Write a Pandas program to import given excel data (coalpublic2013.xlsx ) into a Pandas dataframe.
Next: Write a Pandas program to read specific columns from a given excel file.

Have another way to solve this solution? Contribute your code (and comments) through Disqus.