Change Column Type in Pandas

Better Stack Team
Updated on June 19, 2024

To change the column type in a pandas DataFrame, you can use the astype() method. Here's how you can do it:

 
import pandas as pd

# Sample DataFrame
data = {'A': [1, 2, 3], 'B': [4.0, 5.0, 6.0]}
df = pd.DataFrame(data)

# Original DataFrame
print("Original DataFrame:")
print(df)

# Change column type of column 'A' to float
df['A'] = df['A'].astype(float)

# Updated DataFrame
print("\\nDataFrame with column 'A' converted to float:")
print(df)

In this example, we change the column type of column 'A' to float using the astype() method. You can specify the desired data type as an argument to astype(). In this case, we convert 'A' to float.

You can also convert columns to other types, such as int, str, datetime, etc., by specifying the appropriate data type in the astype() method.

Got an article suggestion? Let us know
Explore more
Licensed under CC-BY-NC-SA

This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.

Make your mark

Join the writer's program

Are you a developer and love writing and sharing your knowledge with the world? Join our guest writing program and get paid for writing amazing technical guides. We'll get them to the right readers that will appreciate them.

Write for us
Writer of the month
Marin Bezhanov
Marin is a software engineer and architect with a broad range of experience working...
Build on top of Better Stack

Write a script, app or project on top of Better Stack and share it with the world. Make a public repository and share it with us at our email.

community@betterstack.com

or submit a pull request and help us build better products for everyone.

See the full list of amazing projects on github