Replacing series values pandas

Question

I have this following dataframe:

And i have this following list:

and i want to replace the series value of team_stat['First Half']['W'] to the list value of first_half_win_result

Possible duplicate of [Add column in dataframe from list](https://stackoverflow.com/questions/26666919/add-column-in-dataframe-from-list) — Aaron_ab, Oct 11 '19 at 08:53

score 1 · Answer 1 · answered Oct 11 '19 at 08:51

1

Try the following code, it would convert list to series for pandas

team_stat['First Half']['W'] = pd.Series(first_half_win_result)

answered Oct 11 '19 at 08:51

oreopot

no errors, after executing the code, the dataframe is still the same no changes are there – slothfulwave612 Oct 11 '19 at 09:02
please upload your code to google colab and let me have a look there – oreopot Oct 11 '19 at 09:22
https://colab.research.google.com/drive/1fDnlPNPLNjdVEDxF2mN8G0_79-Cx6p26 – slothfulwave612 Oct 11 '19 at 09:28
https://colab.research.google.com/drive/177acsnCzZCB6zfMTBp7Mju-RsYBG-WVO – slothfulwave612 Oct 11 '19 at 09:36
CSV? what's the name of the file? I will download it – oreopot Oct 11 '19 at 09:44
https://github.com/Slothfulwave612/La_Liga_2018_19 laliga_2018_19.csv – slothfulwave612 Oct 11 '19 at 09:57

score 1 · Answer 2 · answered Oct 12 '19 at 06:22

1

well i find the solution:

   team_stat = team_stat.transpose()
   team_stat.loc['First Half', 'W'] = first_half_win_result
   team_stat = team_stat.transpose()

answered Oct 12 '19 at 06:22

slothfulwave612

2 Answers2