Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

problem loading csv file without header into oracle table

User_PEQY1Sep 25 2021

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')

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.
run_with_header_none.txt (3.35 KB)run_withhout_header_none.txt (3.35 KB)see attached outputs for both cases , first one is without using the header clause and second case is using header clause.

Comments
Post Details
Added on Sep 25 2021
0 comments
242 views