I have an ID column in Google sheets which is alphanumeric. I am reading the values from Google sheet using Pygsheet into a dataframe. My problem is that when I use the Pygsheet function get_as_df(), some values in the ID column are incorrectly recognized to be in scientific notation and the values that gets read into dataframe show up as “inf”. For example, ID 34E94591 is changed to “inf”. There are no issues if the ID is, for example, 773E893E88 or is just numbers. I don’t think the problem is with the get_as_df() function of Pygsheet but in how pandas is interpreting the values.