how do I create a dataframe based on values from another dataframe?

Question

i have a data frame, from this I created another dataframe,
which consists of a selection after a number of conditions. The result is a number of countries that satisfy the condition n > 11. Now I want to continue working with only these countries. How can I copy values from the first dataset based on the countries in the selection?

My first df looks like:

and the second (so the selection of countries):

In my final df I need every column and row from my 1st df (but only for the countries present in the second df)

DPH · Accepted Answer · 2021-12-15 02:46:26Z

3

I'm not sure about your data and reason using second dataframe, but let first and second data as df1 and df2, then

library(dplyr)

df1 %>%
  filter(Country.o... %in% df2$Country.o...)

(I cannot find out what is the column name. You should not post your data as an imange)

edited Dec 15, 2021 at 2:46

DPH

4,3991 gold badge10 silver badges19 bronze badges

answered Dec 15, 2021 at 0:13

Kra.P

15.2k6 gold badges12 silver badges29 bronze badges

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

1 Comment

EvA Over a year ago

That is exactly what I meant. Thank you so much

Ronak Shah · Accepted Answer · 2021-12-15 01:15:25Z

1

Two options -

Do an inner join

a) Base R -

df3 <- merge(df1, df2, by = 'Country')

b) dplyr -

library(dplyr)
df3 <- inner_join(df1, df2, by = 'Country')

Instead of creating df2 from df1, I would just filter the 1st one to get the resulting dataframe.

df3 <- df1 %>% group_by(Country) %>% filter(n() > 11)

answered Dec 15, 2021 at 1:15

Ronak Shah

391k20 gold badges173 silver badges237 bronze badges

Collectives™ on Stack Overflow

how do I create a dataframe based on values from another dataframe?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related