looking for some solutions? You are welcome.

SOLVED: Insert values into database from data frame only into corresponding rows

sudoCoder:

I have a variable dataframe which has variable values when the script is run on different occasions and the values are directly inserted to database. For example, on first run, it may have:

column1   column2
A            2
B            1
C            3
D            5

while on other run, it may have:

column1   column2
A            4
B            6
D            8

what I am able to do for now inside the database:

column1    run1   run2 
A            2     4
B            1     6
C            3     8
D            5     -

What I want instead:

column1    run1   run2 
A            2     4
B            1     6
C            3     -
D            5     8

Please help me a find a way-around, if not the complete code.



Posted in S.E.F
via StackOverflow & StackExchange Atomic Web Robots
Share:

No comments:

Recent