CODE EXAMPLE FOR PYTHON

when excel is loaded into python, numeric datatype changes to float

# Convert the record_id field from an integer to a float
surveys_df['record_id'] = surveys_df['record_id'].astype('float64')
surveys_df['record_id'].dtype