How to use the where clause in R programming?

0 votes

I'm trying to implement a where clause within ggplot. Is this possible? 

My problem statement is that, I'm using the diamonds table and I want to select records where the cut = "Good". Cut is a field in the Diamond table. The Cut field can equal "Fair", "Good", Very Good", "Premium", and "Ideal".

diamonds[1:5,]
#   carat     cut   color  clarity    depth  table   price         x    y    z
# 1  0.23   Ideal       E      SI2     61.5     55     326      3.95 3.98 2.43  

I want to use some type of conditional statement against a CSV read file. But to keep my example simple, I using the diamond table as a typical example of my problem. I want to filter cut = "Good" but to include fields related to the records = "Good".

Any help would be appreciated.

Dec 24, 2018 in Data Analytics by Sophie may
• 9,050 points
161 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In Data Analytics

0 votes
1 answer

How to change the value of a variable using R programming in a data frame?

Try this: df$symbol <- as.character(df$symbol) df$symbol[df$symb ...READ MORE

answered Jan 11 in Data Analytics by Tyrion anex
• 8,280 points
44 views
0 votes
1 answer

How to use group by for multiple columns in dplyr, using string vector input in R?

dplyr added versions for group_by. This allows you ...READ MORE

answered Apr 12, 2018 in Data Analytics by CodingByHeart77
• 3,680 points

edited Apr 12, 2018 by CodingByHeart77 1,617 views
0 votes
1 answer

How to find out the sum/mean for multiple variables per group in R?

You can use the reshape2 package for ...READ MORE

answered Apr 12, 2018 in Data Analytics by DataKing99
• 8,100 points
173 views
0 votes
1 answer

Which function can I use to clear the console in R and RStudio ?

Description                   Windows & Linux           Mac Clear console                      Ctrl+L ...READ MORE

answered Apr 17, 2018 in Data Analytics by anonymous
624 views
0 votes
1 answer

How to find out the package version which is loaded in R?

You can use sessionInfo() to accomplish that. > ...READ MORE

answered Apr 18, 2018 in Data Analytics by zombie
• 3,690 points
14 views
0 votes
1 answer
0 votes
1 answer

How to connect Java program to the MySQL database?

You can connect your Java code with ...READ MORE

answered May 11, 2018 in Java by parth295
• 4,590 points
83 views
0 votes
1 answer

IN vs OR in the SQL WHERE Clause

I assume you want to know the ...READ MORE

answered Sep 24, 2018 in Database by DataKing99
• 8,100 points
20 views
0 votes
1 answer

Is it possible to use a where clause within ggplot?

You can use the subset function to filter rows ...READ MORE

answered Nov 5, 2018 in Data Analytics by Kalgi
• 35,640 points
19 views
0 votes
1 answer

How to read R errors through JRI

You'll be able to perform those R-Expressions, ...READ MORE

answered Nov 8, 2018 in Data Analytics by Maverick
• 10,000 points
14 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.