Pandas dataframe - move rows from one dataframe to another

Question

I have a python pandas dataframe that has 3 rows in it:

Name  Time  count
AAA   5:45  5
BBB   13:01 8
CCC   11:16 3

I am trying to loop through this dataframe and if the count is greater than 5, i have to populate that row to a new dataframe. I know the count is 2 from a function as only 2 rows are greater than 5. I tried the below code but it is not working. Any help would be appreciated.

for i in range(2):
  if(row['Occurences'] >= 5 ):
    df6.loc[i] = [df4['MachineName'], df4['DateTime'], df4['Count']]
df6

I tried this code - res is empty, I am appending the rows to res based on the condition.

res = pd.DataFrame(columns=('MachineName', 'DateTime', 'Occurences'))
print(pd.concat([res, df4[df4['Occurences'] >= 5]]))
res

Sorry are you just after df4[df4['Count'] >= 5]?

EdChum
– EdChum

2016-06-09 13:14:34 +00:00
Commented Jun 9, 2016 at 13:14 — EdChum
– EdChum, Commented Jun 9, 2016 at 13:14

Community · Accepted Answer · 2017-05-23 11:58:44Z

2

You can use boolean indexing only, as Edchum mentioned in comment:

import pandas as pd

df4 = pd.DataFrame({'Name': {0: 'AAA', 1: 'BBB', 2: 'CCC'}, 
                    'Time': {0: '5:45', 1: '13:01', 2: '11:16'}, 
                    'count': {0: 5, 1: 8, 2: 3}})
print (df4)
  Name   Time  count
0  AAA   5:45      5
1  BBB  13:01      8
2  CCC  11:16      3

res = pd.DataFrame(columns=('MachineName', 'DateTime', 'Occurences'))
res = pd.concat([res, df4[df4['count'] >= 5]])
print (res)
  DateTime MachineName Name Occurences   Time  count
0      NaN         NaN  AAA        NaN   5:45    5.0
1      NaN         NaN  BBB        NaN  13:01    8.0

edited May 23, 2017 at 11:58

CommunityBot

11 silver badge

answered Jun 9, 2016 at 13:16

jezrael

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

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

6 Comments

user3447653 Over a year ago

Thanks, I have edited the question my output constraints. I am not able to print the resultant dataset to which we append the rows.

jezrael Over a year ago

Why do you cannot write? What kind of error? Are column names same in df and df4?

user3447653 Over a year ago

I have edited the question, 'res' returns empty dataframe.

jezrael Over a year ago

I edit answer too, first I think you need append rows to existing DataFrame.

jezrael Over a year ago

Sorry, I think you forget res = - get output of concat to res.

|

Collectives™ on Stack Overflow

Pandas dataframe - move rows from one dataframe to another

1 Answer 1

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related