Change data type of a specific column of a pandas DataFrame
Alter column data type from Int64 to String:
Pandas will always store strings as objects.
import pandas as pd df = pd.DataFrame({'Age': [30, 20, 22, 40, 32, 28, 39], 'Color': ['Blue', 'Green', 'Red', 'White', 'Gray', 'Black', 'Red'], 'Food': ['Steak', 'Lamb', 'Mango', 'Apple', 'Cheese', 'Melon', 'Beans'], 'Height': [165, 70, 120, 80, 180, 172, 150], 'Score': [4.6, 8.3, 9.0, 3.3, 1.8, 9.5, 2.2], 'State': ['NY', 'TX', 'FL', 'AL', 'AK', 'TX', 'TX'] }, index=['Jane', 'Nick', 'Aaron', 'Penelope', 'Dean', 'Christina', 'Cornelia']) print(df.dtypes) df['Age'] = df['Age'].astype(str) print(df.dtypes)
C:\python\pandas examples>python example16.py Age int64 Color object Food object Height int64 Score float64 State object dtype: object Age object Color object Food object Height int64 Score float64 State object dtype: object C:\python\pandas examples>
2018-11-02T14:01:42+05:30
2018-11-02T14:01:42+05:30
Amit Arora
Amit Arora
Python Programming Tutorial
Python
Practical Solution