Question

--Rstudio--

1. The goal of the final question in this assignment is to read in the CSV file SalesJan2009.csv. Then you will filter it into a dataframe for only rows that have United States in the Country column. Once you have that new dataframe, you will filter it again for only results that have a Payment_Type of Visa. That will give you your final dataframe. Now you will write that dataframe to a new CSV file called "VisaUS.csv".

I've attached the csv file:

https://docs.google.com/spreadsheets/d/1PIfnfve_VdW_4THbLh6vKEsTmstYu9EonNV6t8USGZ0/edit?usp=sharing

Answer 1

library(dplyr)
library(xlsx)
# make the directory having your data as your working directory

#dataframe=read.csv("SalesJan2009.csv",sep=";")
dataframe=read.xlsx("SalesJan2009.xlsx",1)
#this gives a general idea of our data
head(dataframe)

#first filter by rows where country is united states
dataframe1 = filter(dataframe, Country=="United States")

head(dataframe1)

#second filter by payment type
dataframe2 = filter(dataframe1,Payment_Type=="Visa")

#storing result in csv file
write.csv(file="VisaUS.csv",dataframe2)

Your file was not opening in csv file format so I have written the code for loading csv file in comment at line number 5

you can see in the image and I had used the xlsx file for storing the data content in a dataframe

The screenshot of VisaUS.csv file is also attached here for your better understanding