problem writing dataframe to oracle

[aliyesami]

i have a simple csv file as follows :

Output:
1,'sami'
2.'john',
3,'mary'
4,'peter'

and i have a table test(id, name)

the code is as follows minus DB connection details since connection is fine :

#df=pd.read_csv('test.csv',encoding= 'unicode_escape', header = None)
df=pd.read_csv('test.csv',encoding= 'unicode_escape' )
print(df)
df.shape
df.info()
df.to_sql('test', engine, index=False, if_exists='append')

[/python]

I am trying to load the csv using pandas data frames but if i dont put the header in csv as "id,name" it does not insert rows and throws "invalid identifier " error.
I want to load this csv file in the table without having to put a header .
please advise .The code and error are below.

Note: I have tried using header=None ,still doesnt work .
Note2: plz note that if I put the header Id,Name in the csv file the code works fine and loads the rows in the table.

see attached outputs for both cases , first one is without using the header clause and second case is using header clause.

Yoriz write Sep-25-2021, 12:45 AM:
Please post all code, output and errors (in their entirety) between their respective tags. Refer to BBCode help topic on how to post. Use the "Preview Post" button to make sure the code is presented as you expect before hitting the "Post Reply/Thread" button.

[Larz60+]

see: https://stackoverflow.com/a/47540978

[aliyesami]

thanks but the link you posted has no relation to my issue. as I stated I don't have any issue in connection or loading as long as I keep the header . I want to know how to load the data when the csv file has no header

[aliyesami]

to any moderator: I think the thing i am trying to do is very common and simple , i am facing issue because I am novice. So I am surprised why I am not getting response .
Did i post this in a wrong group ?
please advise

[SamHobbs]

I am not sure I understand. If I understand then I do not know what your database field names are but perhaps you just need to use something as in the following.

df=pd.read_csv('test.csv', names=["Id", "Name"])