Python Forum
how do change data in a database
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
how do change data in a database
#1
i have list of list

listofplayers = [[player1, 5,1,300,100],[player11, 10,5,650,150],[player23, 17,6,1100,1050]]

and i have a database

player, win, lost, moneywin, moneylost
player1, 3 , 0 , 250 , 50
player2 ...
player3 ...
...

how do i update my database with the new info in my listofplayers? Like this:

player, win, lost, moneywin, moneylost
player1, 5, 1, 300, 100,
player2 ...
player3 ...
player11, 10, 5, 650, 150
player23, 17, 6, 1100, 1050

i tried different things but i just can't find the resources

here's my best attempt:

for i in listofplayers
    for j, k in db.iterrows():
        if i[0] == j['player']:
            index = db.index[db[j]==k].tolist() 
        db.at[index,j] = i[y]
        index = []
    y+=1
    
as you can see i'm having troubles...
this is my very first attempt at pandas and i'm still new to programming
Reply


Messages In This Thread
how do change data in a database - by CompleteNewb - Mar-17-2022, 10:06 PM
RE: how do change data in a database - by Larz60+ - Mar-18-2022, 01:21 AM
RE: how do change data in a database - by Larz60+ - Mar-19-2022, 02:05 AM
RE: how do change data in a database - by Larz60+ - Mar-20-2022, 11:31 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  How to change input data set for character recognition program? plumberpy 5 1,827 Apr-20-2022, 07:46 PM
Last Post: jefsummers
  Using MySQL database images or data dumps Planetary_Assault_Systems 1 1,902 Jul-20-2021, 04:40 PM
Last Post: Larz60+

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020