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

Question

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:

My desired output:

jezrael · Accepted Answer · 2018-11-10 08:10:34Z

2

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)

edited Nov 10, 2018 at 8:10

answered Nov 10, 2018 at 7:18

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

satoshi Over a year ago

I figured this would work but I am trying to make it more readable instead of doing this rank_list,summoner_name_list,tier_list,lp_list,wr_list= [],[],[],[],[]

jezrael Over a year ago

@g_altobelli - check edited answer, you can create dictionary for each iteration and pass it to list, last pass to DataFrame constructor.

user3665224 · Accepted Answer · 2018-11-10 07:37:01Z

0

df = pd.DataFrame(rank_list[0], columns=['A'])

answered Nov 10, 2018 at 7:37

user3665224

1,3673 gold badges17 silver badges35 bronze badges

Collectives™ on Stack Overflow

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

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related