R: Is it possible to create multiple tables based on unique values by looping?

Question

Say if we have a dataframe such the one below:

region          country   city    
North America   USA       Washington   
North America   USA       Boston
Western Europe  UK        Sheffield
Western Europe  Germany   Düsseldorf
Eastern Europe  Ukraine   Kiev
North America   Canada    Vancouver
Western Europe  France    Reims
Western Europe  Belgium   Antwerp
North America   USA       Chicago
Eastern Europe  Belarus   Minsk
Eastern Europe  Russia    Omsk
Eastern Europe  Russia    Moscow
Western Europe  UK        Southampton
Western Europe  Germany   Hamburg
North America   Canada    Ottawa

I would like to know how to loop through this dataframe in order to check if countries are assigned to the right region, same with cities. Usually I do it helping myself with table() function: however this is very time-consuming as this requires several ad-hoc statements such table(df$country[df$region == 'North America') and so on with all the regions involved and countries as well.

Thus, I'm eager to know how to create a loop so I could be able to get this output economizing as much as possible time and lines of code.

Thanks in advance!

What is your disered output?

TobKel
– TobKel

2020-02-12 11:23:29 +00:00
Commented Feb 12, 2020 at 11:23 — TobKel
– TobKel, Commented Feb 12, 2020 at 11:23

Julian · Accepted Answer · 2024-06-07 06:31:25Z

2

df %>% 
  group_by(region) %>% 
  group_split()

edited Jun 7, 2024 at 6:31

Julian

9,6452 gold badges20 silver badges43 bronze badges

answered Feb 12, 2020 at 11:22

TobKel

1,46312 silver badges27 bronze badges

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

Collectives™ on Stack Overflow

R: Is it possible to create multiple tables based on unique values by looping?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related