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

Last update on April 04 2025 13:41:06 (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.

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

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.