Import Data
General Info
Import Export
Data Processing
Analysis
Machine Learning
Useful Snippets

2.0.9 Specify data types of imported data from Excel

Example:

# Set the datatypes of columns in your imported dataframe, use 'dtype' - just like read_csv()  
DF= pd.read_excel("/Path/to/your/data.xls"
                , sheet_name = "titanic3"
                , dtype = { 'survived' :  'int32' ,
                            'name'     :  'object' }
                         )