Sometimes when data is imported to Pandas Dataframe, it always imports as type object. This is fine and well for doing most operations, but I am trying to create a custom export function, and my question is this:
- Is there a way to force Pandas to infer the data types of the input data?
- If not, is there a way after the data is loaded to infer the data types somehow?
I know I can tell Pandas that this is of type int, str, etc.. but I don't want to do that, I was hoping pandas could be smart enough to know all the data types when a user imports or adds a column.
EDIT - example of import
a = ['a']
col = ['somename']
df = pd.DataFrame(a, columns=col)
print(df.dtypes)
>>> somename object
dtype: object
The type should be string?

read_csvfor instance will sniff the dtypes whilstread_exceluses the excel dtypes - EdChumobjectisnp.objectwhich is the correct type for strings, also this is not importing, it's creation - EdChumtype(df['somename'].iloc[0])you will see that it is astr- EdChum