OK, so really all I'm trying to do is take a csv with over 1700 rows of data
shrink it to just a handful of most important observations.
cacao_df <-read_csv("cacao_cleaned.csv")
trimmed_cacao_df <- cacao_df %>%
select(Rating,Company, "Company\nLocation" , "Cocoa\nPercent" )
best_trimmed_cacao_df <- trimmed_cacao_df %>%
filter("Cocoa\nPercent" >= 0.75 & Rating >= 3.9)
OK, so really all I'm trying to do is take a csv with over 1700 rows of data
shrink it to just a handful of most important observations.
cacao_df <-read_csv("cacao_cleaned.csv")
trimmed_cacao_df <- cacao_df %>%
select(Rating,Company, "Company\nLocation" , "Cocoa\nPercent" )
The following is the line of code that seems to be tripping up. The console is filtering out the ratings per instructed, BUT the percentage column is not being filtered!
The original csv had a general text format, so I changed the format of the column
to number, but both formats were not being filtered. So I'm stuck.
best_trimmed_cacao_df <- trimmed_cacao_df %>%
filter("Cocoa\nPercent" >= 0.75 & Rating >= 3.9)
view(best_trimmed_cacao_df)