how do change data in a database

[CompleteNewb]

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

[Larz60+]

Which DBMS?
You will need to use SQL (database query language).

[CompleteNewb]

Which DBMS?
You will need to use SQL (database query language).

i just load a csv file with
db = pd.read_csv('playerhistory.csv')
db.to_csv('playerhistory.csv')

[Larz60+]

Data is arranged serially in a CSV file, when I think of database, I think about tables that are arranged in a DBMS such as sqlite, PostGreSQL, Oracle, MySQL, etc. Tables usually are indexed by one or more fields, and there is a query language SQL that allows access to table data in many different ways, including selecting related date from more tables, all in the same query.

You can store data in a CSV file, but to change that data, you usually read the data in sequentially, looking for the data you want to change, and then writing it back out.

Most everything that I need to store I save in json files, and that works in most instances.
If there is a lot of related data, I'll use PostGreSQL.

There are lots of tutorials available on all of the methods mentioned, and many books written on relational databases and other storage methods.

Lots to learn.

[CompleteNewb]

Data is arranged serially in a CSV file, when I think of database, I think about tables that are arranged in a DBMS such as sqlite, PostGreSQL, Oracle, MySQL, etc. Tables usually are indexed by one or more fields, and there is a query language SQL that allows access to table data in many different ways, including selecting related date from more tables, all in the same query.

You can store data in a CSV file, but to change that data, you usually read the data in sequentially, looking for the data you want to change, and then writing it back out.

Most everything that I need to store I save in json files, and that works in most instances.
If there is a lot of related data, I'll use PostGreSQL.

There are lots of tutorials available on all of the methods mentioned, and many books written on relational databases and other storage methods.

Lots to learn.

But i load the csv file using pandas and in the tutorials they , i think, refer to info that has been loaded into pandas as a database. Is it a bad use of pandas to load the data from a csv file, make modification to it and then save the modified data as a csv file?

[Larz60+]

Is it a bad use of pandas to load the data from a csv file, make modification to it and then save the modified data as a csv file

Not at all, and technically I guess you can call any accumulation of data a database.

The formal definition is:
a structured set of data held in a computer, especially one that is accessible in various ways.
"a database covering nine million workers"