Creating data frames with different names in a loop

Question

I encounter a problem with a loop that creates multiple data frames with different names and assign them a value.

I have a big data frame with different car manufacturers and their CO2 emissions (at the car model level).

After dividing my big data frame into data frames for each manufacturer, I'm trying to subset each of them with their 75% quartile (best 75% cars that pollute the less).

The wrong way (but works) :

subFord <- subset(ford, ford$co2_emissions <= quantile(ford$co2_emissions, 0.75))
subDaimler <- subset(daimler, daimler$co2_emissions <= quantile(daimler$co2_emissions, 0.75))
subGM <- subset(gm, gm$co2_emissions <= quantile(gm$co2_emissions, 0.75))

What I'm trying to do (doesn't work):

manufacturer <- c('ford', 'daimler', 'gm')

for(i in manufacturer) {
paste('sub', i, sep = '') <- subset(i, i$co2_emissions <= quantile(i$co2_emissions, 0.75))
}

Any help is welcomed.

Sarah · Accepted Answer · 2014-11-26 22:58:23Z

1

you'll want to use assign.

assign(paste('sub', i, sep = ''), subset(i, i$co2_emissions <= quantile(i$co2_emissions, 0.75)))

answered Nov 26, 2014 at 22:58

Sarah

7517 silver badges16 bronze badges

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

2 Comments

Synleb Over a year ago

Thanks, but I get an error "i$co2_emission is invalid for atomic vectors ?

Sarah Over a year ago

see: stackoverflow.com/questions/23299684/… ?

Collectives™ on Stack Overflow

Creating data frames with different names in a loop

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related