Question

How can I convert a column with the wrong data type to the correct data type?

Answer 1

You can use the astype() method to convert a column to the desired data type. 

Here's an example:

import pandas as pd

data = {'A': ['1', '2', '3', '4'],
        'B': [1.1, 2.2, 3.3, 4.4]}
df = pd.DataFrame(data)

# Convert column 'A' to integer and column 'B' to float
df['A'] = df['A'].astype(int)
df['B'] = df['B'].astype(float)

print(df)