Changing data types (astype) in Data Analysis Python - Step-by-Step Execution

Concept Flow - Changing data types (astype)

Start with DataFrame

↓

Choose column to change

↓

Call astype(new_type)

↓

Data type changes

↓

Use changed DataFrame for analysis

We start with a DataFrame, pick a column, use astype() to change its data type, then continue analysis with the updated data.

Execution Sample

Data Analysis Python

import pandas as pd

df = pd.DataFrame({'A': ['1', '2', '3'], 'B': [4.5, 5.5, 6.5]})
df['A'] = df['A'].astype(int)
print(df.dtypes)

This code changes column 'A' from string to integer type.

Execution Table

Step	Action	Column 'A' Type Before	Column 'A' Type After	Output
1	Create DataFrame	object (string)	object (string)	A: ['1', '2', '3'], B: [4.5, 5.5, 6.5]
2	Call df['A'].astype(int)	object (string)	int64	Column 'A' converted to integers
3	Assign back to df['A']	object (string)	int64	DataFrame updated with new type
4	Print df.dtypes	int64	int64	A int64 B float64 dtype: object

💡 Data type of column 'A' successfully changed from string to int64

Variable Tracker

Variable	Start	After astype(int)	Final
df['A']	['1', '2', '3'] (object)	[1, 2, 3] (int64)	[1, 2, 3] (int64)

Key Moments - 2 Insights

Why does the data type of column 'A' change after astype(int)?

Because astype(int) converts each string element to an integer, changing the column's data type from object (string) to int64, as shown in execution_table step 2.

What happens if you don't assign the result of astype back to the DataFrame?

The DataFrame column keeps its original type because astype returns a new Series; assignment is needed to update the DataFrame, as shown in execution_table step 3.

Visual Quiz - 3 Questions

Look at the execution table, what is the data type of column 'A' after step 2?

A object (string)

B float64

C int64

D bool

💡 Hint

Check the 'Column 'A' Type After' column in execution_table row for step 2

At which step is the DataFrame actually updated with the new data type?

A Step 1

B Step 3

C Step 2

D Step 4

💡 Hint

Look at the 'Action' and 'Output' columns in execution_table to see when assignment happens

If you skip assigning astype result back to df['A'], what will df['A'] type be after step 3?

A object (string)

B int64

C float64

D None

💡 Hint

Refer to key_moments about assignment necessity and execution_table step 3

Concept Snapshot

Changing data types with astype:
- Use df['col'] = df['col'].astype(new_type)
- Converts data in column to new_type
- Must assign back to update DataFrame
- Common types: int, float, str, bool
- Helps prepare data for analysis or calculations

Full Transcript

This visual execution shows how to change a column's data type in a pandas DataFrame using astype. We start with a DataFrame where column 'A' holds strings. Calling astype(int) converts these strings to integers. However, astype returns a new Series, so we assign it back to df['A'] to update the DataFrame. The execution table tracks each step, showing the data type before and after conversion. Key moments clarify why assignment is needed and how the type changes. The quiz tests understanding of these steps. This method is useful to prepare data for numeric operations or analysis.

Practice

1. What does the astype() method do in pandas?

easy

A. It filters rows based on a condition.

B. It changes the data type of a DataFrame column.

C. It sorts the DataFrame by column values.

D. It merges two DataFrames together.

Solution

1. Step 1: Understand the purpose of astype()

   The astype() method is used to convert the data type of a pandas Series or DataFrame column.

2. Step 2: Compare with other options

   Filtering, sorting, and merging are different pandas operations and not related to changing data types.

3. Final Answer:

   It changes the data type of a DataFrame column. -> Option B

4. Quick Check:

   astype() changes data types [OK]

Hint: Remember: astype() changes column types directly [OK]

Common Mistakes:

• Confusing astype() with filtering or sorting methods
• Thinking astype() merges DataFrames
• Assuming astype() modifies values instead of types

2. Which of the following is the correct syntax to convert a pandas column named 'age' to integer type?

easy

A. astype(df['age'], int)

B. df.astype['age'](int)

C. df['age'].convert(int)

D. df['age'].astype(int)

Solution

1. Step 1: Recall correct method call syntax

   The astype() method is called on the Series object like df['age'].astype(int).

2. Step 2: Check other options for syntax errors

   df.astype['age'](int) uses wrong bracket placement, C uses a non-existent method, and D uses wrong function call style.

3. Final Answer:

   df['age'].astype(int) -> Option D

4. Quick Check:

   Correct syntax is Series.astype(type) [OK]

Hint: Use dot notation on column, then astype(type) [OK]

Common Mistakes:

• Using wrong brackets or parentheses
• Calling astype on DataFrame instead of Series
• Using non-existent methods like convert()

3. Given the DataFrame:

import pandas as pd
df = pd.DataFrame({'score': ['10', '20', '30']})
df['score'] = df['score'].astype(int)
print(df.dtypes)

What will be the output?

medium

A. score int64
dtype: int64

B. score object
dtype: object

C. score int32
dtype: int32

D. score int64
dtype: object

Solution

1. Step 1: Understand the initial data type

   The 'score' column starts as strings (object type) because values are in quotes.

2. Step 2: Apply astype(int) conversion

   Using astype(int) converts the column to integer type, which pandas shows as int64.

3. Step 3: Check the printed dtypes output

   The output shows the column name and its type, followed by dtype info. The correct output is:
   score int64
   dtype: int64

4. Final Answer:

   score int64 dtype: int64 -> Option A

5. Quick Check:

   astype(int) converts to int64 dtype [OK]

Hint: astype(int) changes string numbers to int64 type [OK]

Common Mistakes:

• Expecting dtype to be 'object' after conversion
• Confusing dtype display format
• Thinking astype changes values, not type

4. What error will occur if you try to convert a pandas column with non-numeric strings to integer using astype(int)?

medium

A. KeyError: column not found

B. TypeError: unsupported operand type(s)

C. ValueError: invalid literal for int() with base 10

D. No error, conversion succeeds

Solution

1. Step 1: Understand what astype(int) expects

   The method expects values that can be converted to integers, like numeric strings or numbers.

2. Step 2: Consider non-numeric strings

   If the column contains strings like 'abc', conversion to int is impossible and raises a ValueError.

3. Step 3: Identify the error message

   The error message is: ValueError: invalid literal for int() with base 10.

4. Final Answer:

   ValueError: invalid literal for int() with base 10 -> Option C

5. Quick Check:

   Non-numeric strings cause ValueError on astype(int) [OK]

Hint: Non-numeric strings cause ValueError on int conversion [OK]

Common Mistakes:

• Expecting silent failure or automatic conversion
• Confusing ValueError with TypeError
• Thinking KeyError relates to conversion

5. You have a DataFrame with a column 'price' containing numbers as strings with dollar signs, like '$100', '$250'. How do you convert this column to float type for calculations?

hard

A. df['price'] = df['price'].str.replace('$', '').astype(float)

B. df['price'] = df['price'].astype(float)

C. df['price'] = df['price'].replace('$', '').astype(float)

D. df['price'] = df['price'].astype(str).astype(float)

Solution

1. Step 1: Remove dollar signs from strings

   Dollar signs prevent direct conversion to float. Use str.replace('$', '') to remove them.

2. Step 2: Convert cleaned strings to float

   After removing '$', use astype(float) to convert the column to float type.

3. Step 3: Check other options

   df['price'] = df['price'].astype(float) tries to convert without removing '$' causing error. df['price'] = df['price'].replace('$', '').astype(float) uses replace without str accessor, which won't work on strings. df['price'] = df['price'].astype(str).astype(float) converts to string again unnecessarily.

4. Final Answer:

   df['price'] = df['price'].str.replace('$', '').astype(float) -> Option A

5. Quick Check:

   Remove symbols first, then astype(float) [OK]

Hint: Remove symbols with str.replace before astype(float) [OK]

Common Mistakes:

• Trying to convert strings with symbols directly
• Using replace without str accessor on strings
• Double converting types unnecessarily