Relative Content

Tag Archive for pandasdataframemergecx-oracle

cx_oracle MERGE USING when matched, when not matched and a Pandas dataframe

I have searched stackoverflow, ‘ASK TOM’, and oracle forums, but can’t find a solution to my problem.
I am trying to either update or insert into a table based on whether or not the keys exist in the table. I keep getting ‘right parenthesis missing’ even after removing all parenthesis.
Below is the code:
I read in a csv file to a pandas data frame and then change the np.nan to ”.