data is shown below, Panel.csv: This csv file has three columns….

Question data is shown below, Panel.csv: This csv file has three columns…. data is shown below,Panel.csv: This csv file has three columns. The first column has the zip code, the second column has the year, and the third column has a binary (1/0) variable called airbnb. The value of the airbnb variable is equal to 1 if there is significant Airbnb activity in that zip code during the year of the row. Otherwise it is equal to 0.Yelp.csv:This csv file has a collection of Yelp restaurant reviews written for restaurants in the zip codes from the panel.csv file. Here is the description of the columns:review_date: date of review; address_zipcode:The zip code that the review was written for;price:The relative price of the restaurant. The possible values in this column are: $ , $$ , $$$ , $$$$, and “UNCLAIMED RESTAURANT”. The dollar signs indicate how expensive the restaurant is with more dollar sign indicating more expensive restaurants. The “UNCLAIMED RESTAURANT” value implies that the restaurant was not claimed and therefore the price point is not verified.NYC_reviewer.:This is a binary variable (1/0) that indicates whether the reviewer that wrote the restaurant review is from New York City. 1 means that review is written by a resident of NYC and 0 means that it was written by a visitor to NYC.Question: Difference in ratings by visitors and NYC residents. (Please use R or Python to answer the question)Determine whether there is a statistically significant difference between the average ratings of the reviews written by residents of NYC and those written by visitors to NYC. In this part, you don’t need to consider other factors that may impact average rating, only whether the difference between the visitors and residents is statistically different. Design a statistical model that will estimate the change in average rating if a reviewer is a visitor vs. if the reviewer is a resident of NYC. In this model, you will need to control for other factors that could impact the rating. You must think about the following items specifically: Are reviewers giving higher/lower ratings in one year relative to another? Do reviewers give higher/lower ratings to more/less expensive restaurants? Provide succinct rational for the controls included in the statistical model.Sample data:Panel data:zipcode,year,airbnb10026.0,2009,010026.0,2010,010026.0,2011,010026.0,2012,110026.0,2013,110026.0,2014,110026.0,2015,110031.0,2009,010031.0,2010,010031.0,2011,010031.0,2012,110031.0,2013,110031.0,2014,110031.0,2015,110032.0,2009,010032.0,2010,010032.0,2011,010032.0,2012,010032.0,2013,110032.0,2014,110032.0,2015,110033.0,2009,010033.0,2010,010033.0,2011,0Yelp data:review_date address_zipcode review_rating price NYC_reviewer13-10-2015 11432 5.0 star rating $ 024-02-2015 10033 2.0 star rating $ 013-05-2014 10033 4.0 star rating $ 013-06-2015 11234 5.0 star rating UNCLAIMED RESTAURANT 112-05-2015 11234 4.0 star rating UNCLAIMED RESTAURANT 030-07-2011 11234 4.0 star rating UNCLAIMED RESTAURANT 119-04-2015 11234 4.0 star rating $$ 018-09-2015 11234 3.0 star rating $$ 010-03-2015 11234 3.0 star rating $$ 108-11-2015 11234 5.0 star rating $$ 118-06-2014 11234 1.0 star rating $$ 006-06-2015 11234 4.0 star rating $$ 103-10-2010 11234 3.0 star rating $$ 120-08-2014 11234 5.0 star rating $$ 129-05-2015 11234 3.0 star rating $$ 006-02-2013 11234 4.0 star rating $$ 011-04-2014 11234 5.0 star rating $$ 105-03-2015 11234 2.0 star rating $$ 106-06-2013 11234 4.0 star rating $$ 118-12-2014 11234 5.0 star rating $$ 023-11-2014 11234 5.0 star rating $$ 014-10-2014 11234 2.0 star rating $$ 119-03-2010 11234 4.0 star rating $$ 125-04-2011 11234 5.0 star rating $$ 1 Computer Science Engineering & Technology Python Programming IS 731 Share QuestionEmailCopy link Comments (0)