Hey,
I have attached the files requiredfor the assignment.
Four csv files are the data files and the R file has instructions to query how it needs to be done.Please answer the questions under each query.
consumer_id,pop_up,saved_discount 60013773516,1,1 59813803514,1,0 59787863517,1,1 59773453517,1,0 59730883514,1,0 59720363514,1,1 59700183513,1,0 59662023513,1,1 59642533516,1,1 59523113517,1,0 59482393513,1,0 59472493516,1,1 59468393514,1,1 59433713515,1,0 59424663516,1,0 59421143510,1,1 59398933511,1,1 59385683515,1,1 59359563517,1,0 59344473513,1,0 5932658359,1,1 59312243511,1,1 59310713515,1,0 59304183514,1,0 5918416359,1,0 59138793510,1,0 59130223511,1,0 59122163513,1,0 59090873516,1,0 5908622359,1,0 59039623511,1,0 5903238359,1,1 5901852353,1,0 58999823517,1,1 5896714356,1,0 58960113514,1,0 58943833511,1,0 5893430353,1,0 5891948355,1,0 58889623516,1,0 5887187352,1,0 5880461355,1,0 5879205358,1,0 58737153512,1,1 5873371356,1,0 5867837353,1,0 5866304353,1,0 58652393516,1,0 58651473517,1,1 58636003513,1,0 58568793517,1,1 5854738358,1,0 58544003512,1,0 5854066353,1,0 58453613517,1,0 5845354355,1,0 58446783513,1,0 5844036356,1,0 58209793511,1,0 58036683513,1,0 5797585358,1,1 57947063510,1,0 5794003359,1,1 57926413510,1,0 57902273516,1,0 57897573511,1,0 57888283516,1,1 57836013511,1,1 5781638358,1,0 57719813510,1,1 57707863517,1,1 5767274352,1,1 57643583515,1,0 5762514359,1,1 57392333513,1,1 5739141352,1,1 57388853513,1,0 57340853517,1,1 57334913510,1,1 5731008358,1,0 5727117352,1,0 57187333515,1,0 57186963516,1,0 57161733515,1,0 5714988352,1,1 5712977353,1,0 5712939357,1,1 5709359359,1,0 5709199355,1,1 57075773511,1,0 5706211359,1,1 57058253515,1,0 57049033513,1,0 5703821354,1,0 5702619359,1,0 5702350353,1,0 5701155357,1,0 5700851356,1,0 5699995359,1,0 5699353351,1,0 5697717352,1,0 5696956359,1,0 5695720359,1,0 5691807359,1,0 5691616359,1,0 56910673515,1,0 56910503511,1,0 56903503513,1,0 5688982353,1,0 56852573517,1,0 5684915357,1,1 5682812356,1,0 5680962359,1,0 56806963517,1,1 5680382359,1,0 5675340357,1,0 5675333355,1,0 5675111358,1,0 56742753517,1,1 56733773511,1,0 5672981359,1,0 5669844351,1,1 5666386352,1,0 56635453517,1,0 5661015359,1,0 5660803352,1,0 5655267352,1,1 56552363512,1,0 5654093354,1,1 5652280355,1,1 5651801358,1,0 5650576351,1,0 5649914358,1,1 5649396357,1,0 5642069353,1,0 56362803512,1,1 56358253514,1,0 5634934356,1,0 56346823513,1,0 5632497352,1,0 5632312359,1,0 5631230354,1,1 5630486357,1,1 56300043514,1,0 56270283515,1,0 56266943513,1,0 5625444359,1,0 5623433357,1,0 56191603513,1,1 5616992353,1,0 56150253514,1,0 5610044352,1,0 56076863513,1,0 5606511355,1,0 5605026352,1,0 56019503513,1,1 5601523354,1,0 5600182351,1,1 55999743515,1,0 55986253516,1,0 55952803515,1,0 55947403513,1,0 5592173352,1,0 5592012352,1,0 5590544352,1,0 5588916353,1,0 5586622358,1,0 55864553512,1,0 55856633517,1,0 5585021352,1,0 5582969352,1,0 5579600359,1,0 55771943515,1,1 5575282353,1,0 5572441351,1,0 55709803515,1,0 5569533351,1,0 55669143515,1,0 55668773510,1,0 5566860352,1,0 55642863515,1,1 5562312353,1,1 55623053516,1,0 5559930359,1,0 55598003513,1,0 5559794351,1,0 5556915359,1,0 5550555351,1,0 55496103513,1,0 55487363511,1,0 55482003510,1,0 5547968357,1,0 5547494355,1,0 5545773351,1,0 55456293511,1,0 55448683512,1,1 55440733511,1,0 5543434352,1,0 5541720353,1,0 55413313515,1,1 55410103511,1,0 5537747359,1,0 5537471353,1,0 5537419351,1,1 55370133516,1,0 5536078359,1,1 5535996357,1,0 5535859355,1,0 5535637352,1,0 5534562352,1,1 5534050354,1,0 5533978357,1,0 55322923513,1,0 5529674355,1,1 5529223357,1,0 5528868359,1,0 5528325352,1,0 5527885355,1,0 55275193510,1,1 5527274353,1,1 55245943510,1,0 5524181351,1,0 5523733358,1,0 55234503512,1,0 55224603511,1,0 5517879353,1,0 5517558358,1,0 5515608356,1,0 5515523355,1,0 5514632356,1,1 5514274355,1,0 5513505353,1,0 55132463512,1,0 5509881359,1,0 55092633516,1,1 5509034352,1,0 5508884353,1,0 55086623510,1,1 5508617351,1,0 55081743514,1,0 55074983513,1,0 5507481351,1,0 5506576352,1,0 5505906355,1,0 5505609351,1,1 5505456353,1,0 55052963517,1,1 5505203355,1,0 55047563514,1,0 5504596359,1,0 55039023512,1,1 55026393516,1,0 5502479352,1,1 55008883513,1,0 54952383512,1,1 54937223510,1,0 54933333517,1,1 5493036351,1,0 5492909359,1,0 5492886359,1,0 5492046352,1,0 5491032359,1,1 5490912354,1,0 5490813352,1,1 5490370353,1,0 5490028353,1,1 5489626353,1,1 5489411359,1,1 5488964352,1,0 54879983510,1,0 5487929351,1,0 54877073511,1,1 5487615353,1,1 54868543516,1,0 5484973359,1,1 5484904352,1,1 5484362356,1,0 5484287352,1,0 54838463516,1,1 54835493513,1,1 54811943513,1,1 5480753353,1,0 5480562354,1,1 5480470351,1,0 5479702351,1,0 5478101353,1,1 54780643512,1,0 5477906354,1,0 5475841354,1,0 5475827351,1,0 54756813516,1,1 54756123514,1,1 5475070353,1,0 54737483512,1,0 5473359351,1,0 54732433515,1,0 54731443516,1,0 5472970351,1,1 54716453517,1,1 54716383510,1,1 5471492355,1,1 54708463517,1,0 5468249353,1,0 54679763512,1,1 5467860359,1,0 5467693357,1,0 54646543513,1,0 54640503511,1,0 5463183355,1,0 54629193515,1,1 54625683511,1,0 54623533514,1,0 5461097352,1,0 54607863516,1,0 5458653358,1,0 54582953517,1,0 54581653510,1,0 5458042354,1,0 5457724359,1,0 5456482353,1,1 54553173510,1,0 54538873510,1,0 5452934354,1,0 54529273513,1,0 54521183516,1,1 54476643513,1,0 5447619353,1,0 54468963514,1,0 54458993517,1,0 5443642357,1,1 54421023515,1,0 54416863517,1,0 54382423510,1,1 5438112354,1,0 5437498359,1,1 54363783514,1,1 54362483514,1,1 54339403515,1,1 54330323517,1,1 5431960357,1,0 5430888355,1,0 5430314351,1,1 5425129353,1,1 54249003510,1,0 54224013516,1,0 5420308352,1,1 5418053352,1,0 5417964359,1,1 5417872352,1,1 5417506353,1,1 54165163516,1,0 5416417355,1,0 54117883510,1,0 54112073510,1,1 54107813511,1,1 5409716351,1,0 5404476353,1,0 54021373517,1,0 53978083515,1,0 5394968353,1,1 53936713513,1,0 5392056357,1,1 5389100351,1,0 5387670353,1,0 5384822354,1,0 5384167355,1,0 5382873358,1,1 5382064358,1,0 5379972355,1,0 5375639351,1,0 53755613512,1,0 53753323511,1,0 5371815352,1,0 53703683517,1,0 5369126355,1,0 5365548358,1,0 5364961352,1,1 5359141351,1,0 5354986353,1,0 5352357351,1,1 53516953514,1,0 53470563513,1,0 53456493516,1,0 53443383510,1,0 53442603517,1,0 53437063514,1,1 53408043510,1,1 53406203511,1,0 5340590353,1,0 5338184358,1,0 53361973510,1,0 53348963512,1,0 53324103514,1,1 53318403517,1,0 53313903517,1,0 5331284351,1,1 5329755359,1,0 5327607358,1,1 5327218358,1,0 53265943511,1,1 53191903516,1,1 53129003513,1,0 5312351358,1,0 5311439359,1,0 5311170351,1,0 5310821351,1,0 5310616359,1,0 5306312352,1,1 53057733510,1,0 53056983514,1,1 53016523513,1,0 5301102356,1,1 53009453515,1,0 5298211356,1,0 5297559359,1,1 5297535351,1,0 5295944359,1,0 5294893355,1,1 5294169358,1,1 5293926356,1,1 5289998359,1,0 5288809355,1,0 52886563512,1,0 5286270358,1,1 52858773512,1,1 52857853511,1,1 52851503515,1,0 5282081353,1,0 52819613514,1,0 5281558353,1,0 5281367359,1,0 52807423510,1,0 52794493515,1,0 5278718355,1,1 5275984351,1,0 52758923516,1,1 52740793514,1,0 5273393353,1,1 5273065352,1,0 52729453517,1,1 5272655357,1,1 5270095359,1,0 52697163516,1,1 52677123510,1,0 5260676359,1,0 52605533514,1,1 5259168352,1,1 5258550357,1,0 5256761359,1,0 5254149353,1,0 52541013513,1,1 52510633510,1,0 5250868357,1,0 52495413517,1,0 5246809357,1,1 52465883516,1,0 5243143359,1,1 5243105357,1,0 52429243514,1,0 52396273515,1,0 5238910358,1,0 5238798354,1,1 52385693516,1,0 52385453515,1,0 5235568354,1,0 5235179358,1,0 52351313513,1,0 5234363353,1,1 5233342359,1,0 5230969353,1,0 52299323513,1,0 52248073514,1,0 5221387353,1,0 52196983513,1,0 52152183515,1,0 5214013359,1,0 5209514356,1,0 52047243513,1,0 5201037357,1,1 5200627359,1,0 51993273516,1,0 5198603353,1,0 51957633515,1,0 5188475352,1,0 51870583513,1,1 51826333515,1,0 51822443515,1,0 51809053515,1,0 5176977351,1,0 51751853510,1,1 51750243513,1,0 51743623510,1,0 51739073510,1,1 5168576358,1,0 51612563513,1,1 51598573511,1,0 51579763515,1,0 5157211358,1,0 5155309355,1,0 5154654358,1,0 5149162354,1,0 5148530358,1,0 5146871352,1,0 51460313515,1,0 5144495353,1,1 51408793516,1,0 51399343516,1,0 51397123510,1,0 5137053353,1,1 51341513514,1,0 51338023514,1,1 51292703514,1,0 51287613514,1,0 51153033516,1,1 5115297352,1,1 5105137353,1,1 51028083512,1,1 5101757358,1,0 5100453356,1,1 51002933514,1,1 50976473513,1,1 5095384359,1,0 50939603513,1,1 50939223516,1,0 5092383359,1,1 50913933513,1,0 5091386353,1,0 5090402352,1,1 50902803510,1,1 50891303514,1,0 50877543510,1,0 5085866352,1,0 50810593516,1,0 5078059359,1,0 5076055359,1,1 50759973515,1,1 50746553512,1,1 5074389352,1,1 50729653516,1,0 5071845352,1,0 50715243510,1,0 5071500356,1,0 5066254351,1,0 50616553510,1,0 50610683510,1,1 5059928351,1,0 50598743517,1,0 5059010357,1,0 5057252351,1,0 5056675355,1,0 50557913513,1,1 5053933353,1,0 5053544353,1,0 50528993515,1,1 5051557359,1,1 50486323513,1,0 5047550354,1,0 5047406351,1,0 5047345354,1,0 50469113516,1,0 5042104359,1,1 5040759353,1,1 5040278353,1,0 5040254359,1,0 50366153515,1,1 5031412353,1,1 50284673510,1,0 5027781356,1,0 5027521359,1,0 5024940359,1,1 5020539359,1,0 50158873517,1,0 5010028357,1,0 50093983512,1,0 5005345352,1,0 4996545357,1,1 49935203515,1,0 4993476359,1,0 49925543510,1,0 49919603516,1,0 49906283517,1,1 49892333510,1,0 49865773510,1,0 49815893516,1,1 4981305352,1,0 4980544359,1,0 4979869353,1,0 4977292359,1,1 49771313512,1,0 4975847355,1,1 4974918352,1,1 4974642353,1,0 4974512358,1,0 4968825356,1,0 49686103517,1,1 49683063516,1,0 49673613514,1,0 49670263513,1,0 4966722351,1,0 4966241359,1,0 4964506355,1,0 49643463516,1,0 49635303510,1,0 4963028352,1,1 4962861355,1,0 49621063510,1,1 4957676351,1,1 4955504352,1,0 4955139353,1,0 4954903359,1,0 49507383510,1,0 49485133513,1,0 49484903513,1,0 49453763516,1,0 49420233516,1,0 49403573516,1,0 49383923517,1,0 49346223510,1,0 4925620359,1,0 49195753511,1,1 4918028353,1,0 4915249355,1,1 49133133514,1,0 4908050351,1,0 4906476354,1,0 4903253352,1,1 4901976351,1,0 48985113510,1,0 4898269359,1,1 4898016359,1,0 4894582352,1,0 4894254359,1,1 48931893512,1,0 4892595358,1,0 48836303515,1,0 48827253510,1,1 48825343510,1,0 4882152359,1,1 4880820359,1,1 4880271359,1,0 4872665352,1,0 4870944352,1,1 48705793513,1,0 48697573510,1,0 4864172355,1,0 4856870351,1,0 4854593351,1,1 4849186358,1,0 48472503516,1,1 4844242352,1,0 4841647357,1,0 4839934352,1,0 4837732359,1,0 48345643511,1,0 48345263514,1,0 48338713510,1,1 4830054359,1,1 4829829357,1,0 4828365356,1,0 48267053515,1,0 48265143512,1,0 4825821353,1,1 48231243516,1,0 48227763517,1,0 4821717355,1,0 4820277356,1