Question: Where to use specifically FILTER?SELECT? on cols or rows? PS don;t use pipes #download data file flightsSeptember.csv to your local system. ,library(dplyr) #5.For each of

Where to use specifically FILTER?SELECT? on cols or rows?

PS don;t use pipes

#download data file flightsSeptember.csv to your local system. ,library("dplyr")

#5.For each of the following specification, display the data from the above data frameusing only dplyr package functions: #a.All the columns for flights leaving from JFK or EWR. filter(flights,origin=="JFK"|origin=="EWR")

#b.All the columns for flights leaving from JFK or EWR and arriving at ORD. filter(flights,origin=="JFK"|origin=="EWR",dest=="ORD")

#c.The first 10 columns for flights whose airtime is less than or equal to 120 minutes.

#d.The last 10 columns for flights whose distance is greater than or equal to 1000 miles. #e.The first 5 columns and the last 4 columns for flights for thecarriers UA, AA, and EV.

#f.Columns year, month, day, flight, and arrival delay for flights leaving LGA with departure delay more than 240 minutes.

#h.Columns flight, tailnum, origin and dest for flights of the carriers UA, AA, and EV.

#j.Columns year, month, day, flight, and arrival delay #for flights leaving LGAor EWR and with departure delay more than 240 minutes.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!