data showing as int64 code example

Example 1: 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

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

surveys_df.plot_id.astype("float")