Rewrite the title as: How to convert data type of "unnamed 0" column of pandas dataframe from int64 to string or object

Question

I'm working on a small project trying to send a dataframe from pandas to a mysql database.

My dataframe contains default unnamed columns and I want to send it to mysql server. My sql schema contains an id column of varchar(255) data type.

create table users_sample(
    id varchar(255) NOT NULL PRIMARY KEY,
    #other_columns)

When I try to send the code to the server, I get the following error

sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (1364, "Field 'id' has no default value")

When I searched for a solution, it was suggested to change the data type from varchar to int and add auto_increment constraints.

Please provide a solution.

Thanks in advance.

Answer 1

Maybe it can help you

d1[['colname']] = d1[['colname']].astype(float)