dtypes for column data types in Pandas

Introduction

We use dtypes to know what kind of data is stored in each column of a table. This helps us understand and work with the data correctly.

When you want to check if a column has numbers or words.

When you need to convert data from one type to another, like text to numbers.

When you want to find columns with dates to do time calculations.

When you want to make sure data is in the right format before analysis.

When you want to optimize memory by choosing the best data type.

Syntax

Pandas

DataFrame.dtypes

This returns a list showing the data type of each column.

It does not change the data, just shows the types.

Examples

Shows data types of columns 'age' and 'name'.

Pandas

import pandas as pd

data = {'age': [25, 30, 22], 'name': ['Ann', 'Bob', 'Cara']}
df = pd.DataFrame(data)
print(df.dtypes)

Changes 'age' column to float type and shows updated types.

Pandas

df['age'] = df['age'].astype('float')
print(df.dtypes)

Sample Program

This code creates a table with numbers, decimals, true/false, and text. Then it prints the type of data in each column.

Pandas

import pandas as pd

# Create a simple table with different types of data
data = {
    'id': [1, 2, 3],
    'score': [88.5, 92.3, 79.0],
    'passed': [True, True, False],
    'name': ['Alice', 'Bob', 'Charlie']
}
df = pd.DataFrame(data)

# Print the data types of each column
print(df.dtypes)

Important Notes

Object type usually means text or mixed data.

Use astype() to change a column's data type.

Knowing dtypes helps avoid errors in calculations and analysis.

Summary

dtypes tell you the kind of data in each column.

They help you understand and prepare data for analysis.

You can check dtypes anytime with DataFrame.dtypes.

Practice

1. What does the dtypes attribute in a pandas DataFrame tell you?

easy

A. The names of the columns

B. The number of rows in the DataFrame

C. The total memory used by the DataFrame

D. The type of data stored in each column

Solution

1. Step 1: Understand what dtypes means

   The dtypes attribute shows the data type of each column in a DataFrame, like integer, float, or string.

2. Step 2: Compare options with the definition

   Only the type of data stored in each column correctly describes that dtypes tells the type of data stored in each column.

3. Final Answer:

   The type of data stored in each column -> Option D

4. Quick Check:

   dtypes = data type per column [OK]

Hint: Remember: dtypes show column data types, not counts or names [OK]

Common Mistakes:

• Confusing dtypes with DataFrame shape
• Thinking dtypes shows column names
• Assuming dtypes shows memory usage

2. Which of the following is the correct way to check the data types of columns in a pandas DataFrame named df?

easy

A. df.dtypes

B. df.types()

C. df.get_dtypes()

D. df.columns.types

Solution

1. Step 1: Recall the correct pandas syntax

   To check column data types, pandas uses the attribute dtypes without parentheses.

2. Step 2: Evaluate each option

   df.dtypes uses df.dtypes, which is correct. Options B and C use incorrect method names, and D is not a valid attribute.

3. Final Answer:

   df.dtypes -> Option A

4. Quick Check:

   Use df.dtypes to check column types [OK]

Hint: Use df.dtypes without parentheses to see column types [OK]

Common Mistakes:

• Adding parentheses after dtypes
• Using non-existent methods like get_dtypes()
• Confusing dtypes with columns attribute

3. Given the following code:

import pandas as pd
data = {'A': [1, 2, 3], 'B': [1.5, 2.5, 3.5], 'C': ['x', 'y', 'z']}
df = pd.DataFrame(data)
print(df.dtypes)

What will be the output?

medium

A. A object
B object
C object
dtype: object

B. A float64
B int64
C object
dtype: object

C. A int64
B float64
C object
dtype: object

D. A int32
B float32
C string
dtype: object

Solution

1. Step 1: Identify data types from the data dictionary

   Column 'A' has integers (1,2,3) so type is int64 by default. Column 'B' has floats (1.5,2.5,3.5) so type is float64. Column 'C' has strings ('x','y','z') which pandas treats as object type.

2. Step 2: Match with the printed output format

   The output shows each column name with its dtype, followed by 'dtype: object'. A int64 B float64 C object dtype: object matches this exactly.

3. Final Answer:

   A int64 B float64 C object dtype: object -> Option C

4. Quick Check:

   Integers=int64, floats=float64, strings=object [OK]

Hint: Integers default to int64, floats to float64, strings to object [OK]

Common Mistakes:

• Assuming strings show as 'string' dtype
• Confusing int32 with int64
• Mixing float and int types

4. You run this code:

import pandas as pd
df = pd.DataFrame({'X': [1, 2, 3], 'Y': ['a', 'b', 'c']})
print(df.dtypes())

But get an error. What is the problem?

medium

A. The DataFrame is empty

B. You should use df.dtypes without parentheses

C. Column names must be integers

D. You need to import numpy first

Solution

1. Step 1: Identify the error cause

   The code uses df.dtypes() with parentheses, but dtypes is an attribute, not a method.

2. Step 2: Correct the syntax

   Remove the parentheses and use df.dtypes to get the data types without error.

3. Final Answer:

   You should use df.dtypes without parentheses -> Option B

4. Quick Check:

   dtypes is attribute, not method [OK]

Hint: Remember: dtypes has no parentheses, it's not a function [OK]

Common Mistakes:

• Calling dtypes as a function
• Thinking DataFrame is empty causes error
• Believing numpy import is needed for dtypes

5. You have a DataFrame df with columns: age (integers), income (floats), and member (True/False). You want to check the data types and convert member to integer (1 for True, 0 for False). Which code correctly does this?

hard

A. print(df.dtypes)
df['member'] = df['member'].astype(int)

B. print(df.types)
df['member'] = int(df['member'])

C. print(df.dtypes())
df['member'] = df['member'].to_int()

D. print(df.columns)
df['member'] = df['member'].astype('bool')

Solution

1. Step 1: Check data types correctly

   Use df.dtypes (no parentheses) to print data types. Options B and C use incorrect syntax.

2. Step 2: Convert boolean column to integer

   Use astype(int) to convert True/False to 1/0. print(df.dtypes) df['member'] = df['member'].astype(int) does this correctly. print(df.columns) df['member'] = df['member'].astype('bool') converts to bool again, which is unnecessary.

3. Final Answer:

   print(df.dtypes) df['member'] = df['member'].astype(int) -> Option A

4. Quick Check:

   Use df.dtypes and astype(int) for boolean to int [OK]

Hint: Use df.dtypes and astype(int) to convert booleans to 0/1 [OK]

Common Mistakes:

• Calling dtypes as a method
• Trying to convert column with int() directly
• Converting boolean to bool again instead of int