Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Python - How to store values from a while loop into a pandas dataframe?

I am trying to get the values from my list and store them into a dataframe

while (rank < len(get_rank)) and (summoner_name < len(get_summoner_name)) and (tier < len(get_tier)) and (lp < len(get_LP)) and (wr < len(get_wr)):
        contains1 = get_rank[rank]
        rank += 1
        rank_list = [rank for rank in contains1]
        df = pd.DataFrame({'A':rank_list[0]},index = [0])
        print(df)

My rank_listoutputs:

[1]
[2]
[3]

My rank_list[0] outputs:

1
2
3

My current output:

   A
0  1
   A
0  2
   A
0  3

My desired output:

   A
0  1
1  2
2  3
like image 451
satoshi Avatar asked Oct 18 '25 13:10

satoshi


1 Answers

I believe you can append first value of contains1 to list and then out of loop create DataFrame by contructor:

L = []
while (rank < len(get_rank)) and (summoner_name < len(get_summoner_name)) and (tier < len(get_tier)) and (lp < len(get_LP)) and (wr < len(get_wr)):
        rank = get_rank[rank]
        summoner_name = get_summoner_name[rank]
        tier = get_tier[rank]
        lp = get_lp[rank]
        wr = get_wr[rank]
        d = {'rank':rank,
             'summoner_name':summoner_name,
             'tier':tier,
             'lp':lp,
             'wr':wr}

        L.append(d)

df = pd.DataFrame(L)
print(df)
like image 55
jezrael Avatar answered Oct 21 '25 02:10

jezrael



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!