Create a dataframe using for loop results in Python

Question

When I run the for loop below

for i in df:
    d = df[pd.notnull(df[i])]
    c = df[df[i]>str(1)].count()
    print(c)

I get a results below

1     244
2     122
3      53
4      75
dtype: int64
1     122
2     206
3      62
4      77
dtype: int64

I want to create a data frame which looks like below

Can someone help me code?

Possible duplicate of Append column to pandas dataframe

Jeanne Chaudanson
– Jeanne Chaudanson

2017-07-20 12:25:50 +00:00
Commented Jul 20, 2017 at 12:25 — Jeanne Chaudanson
– Jeanne Chaudanson, Commented Jul 20, 2017 at 12:25

Jeanne Chaudanson · Accepted Answer · 2017-07-20 16:41:27Z

1

Having an excerpt of your initial data would be useful, but from what I can gather you're only trying to append the two arrays together to obtain a pandas dataframe. That can be easily done with something like:

data = pd.DataFrame()

for i in df:
    d = df[pd.notnull(df[i])]
    c = df[df[i]>str(1)].count()
    data = data.join(c)

print(data)

answered Jul 20, 2017 at 16:41

Jeanne Chaudanson

1319 bronze badges

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

Collectives™ on Stack Overflow

Create a dataframe using for loop results in Python

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related