Converting Data Types

Python

Data Preprocessing

Shows how to convert dataframe column to different data types. We see how to convert to string, integer, float and datetime.

 1|  #GENERAL SYNTAX
 2|  df[column_name] = df[column_name].astype(data type)
 3|  
 4|  #CONVERTING TO STRING
 5|  df[column_name] = df[column_name].astype(str)
 6|  
 7|  #CONVERTING TO INTEGER
 8|  df[column_name] = df[column_name].astype(int)
 9|  
10|  #CONVERTING TO FLOAT
11|  df[column_name] = df[column_name].astype(float)
12|  
13|  #CONVERTING TO DATETIME
14|  df[column_name] = pd.to_datetime(df[column_name] )

ANALYSEUP

2 Upvotes

Tags: Data-cleaning

Did you find this snippet useful?

Sign up to bookmark this in your snippet library

Normalize Windowed Time Series

Python

Data Preprocessing

Scaler | Normalize | Scale | Min-max

4

Convert All Non-numeric Columns to Category Data Types

Python

Data Preprocessing

4

Creating a Running Total Column in Pandas

Python

Data Preprocessing

3

Pivoting Pandas Dataframes

Python

Data Preprocessing

3

Renaming Columns in a Pandas Dataframe Using Dictionaries & Lists

Python

Data Preprocessing

2

How to Remove Punctuation From Text with Python

Python

Data Preprocessing

Nlp | String | Punctuation

2

How To Set First Row of a Pandas Dataframe as Column Headers

Python

Data Preprocessing

2

How to Create Different Aggregations Using GroupBy, Agg & Dictionaries

Python

Data Preprocessing

2

Using Pandas GroupBy Transform Function

Python

Data Preprocessing

Transform | Groupby

2

Extract Date & Time Features From a Pandas Date Column

Python

Data Preprocessing

2