Given the file dpc-covid19-ita-regioni.csv, containing data about the new Coronavirus infections in Italy split by regions from February 2020, code your Pig script to find out the sum of new infections per day ( select sum(nuovi_positivi) group by data).
Take this simple output as a reference:
(2020-06-15T17:00:00,303)
(2020-06-16T17:00:00,210)
(2020-06-17T17:00:00,329)
(2020-06-18T17:00:00,333)
(2020-06-19T17:00:00,251)
(2020-06-20T17:00:00,262)
(2020-06-21T17:00:00,224)
(2020-06-22T17:00:00,218)
(2020-06-23T17:00:00,122)
(2020-06-24T17:00:00,190)
(2020-06-25T17:00:00,296)
(2020-06-26T17:00:00,259)
(2020-06-27T17:00:00,175)
(2020-06-28T17:00:00,174)
(2020-06-29T17:00:00,126)
(2020-06-30T17:00:00,142)
(2020-07-01T17:00:00,187)
(2020-07-02T17:00:00,201)
(2020-07-03T17:00:00,223)
(2020-07-04T17:00:00,235)
(2020-07-05T17:00:00,192)
(2020-07-06T17:00:00,208)
(2020-07-07T17:00:00,138)
(2020-07-08T17:00:00,193)
(2020-07-09T17:00:00,229)
(2020-07-10T17:00:00,276)
(2020-07-11T17:00:00,188)
(2020-07-12T17:00:00,234)
(2020-07-13T17:00:00,169)
(2020-07-14T17:00:00,114)
(2020-07-15T17:00:00,163)
(2020-07-16T17:00:00,230)
(2020-07-17T17:00:00,233)
(2020-07-18T17:00:00,249)
(2020-07-19T17:00:00,219)
(2020-07-20T17:00:00,190)
(2020-07-21T17:00:00,129)
(2020-07-22T17:00:00,282)
(2020-07-23T17:00:00,306)
(2020-07-24T17:00:00,252)
(2020-07-25T17:00:00,275)
(2020-07-26T17:00:00,255)
(2020-07-27T17:00:00,170)
(2020-07-28T17:00:00,212)
(2020-07-29T17:00:00,289)
(2020-07-30T17:00:00,386)
(2020-07-31T17:00:00,379)
(2020-08-01T17:00:00,295)
(2020-08-02T17:00:00,239)
(2020-08-03T17:00:00,159)
(2020-08-04T17:00:00,190)
(2020-08-05T17:00:00,384)
(2020-08-06T17:00:00,402)
(2020-08-07T17:00:00,552)
(2020-08-08T17:00:00,347)
(2020-08-09T17:00:00,463)
(2020-08-10T17:00:00,259)
(2020-08-11T17:00:00,412)
(2020-08-12T17:00:00,481)
(2020-08-13T17:00:00,523)
(2020-08-14T17:00:00,574)
(2020-08-15T17:00:00,629)
(2020-08-16T17:00:00,479)
(2020-08-17T17:00:00,320)
(2020-08-18T17:00:00,403)
(2020-08-19T17:00:00,642)
(2020-08-20T17:00:00,845)
(2020-08-21T17:00:00,947)
(2020-08-22T17:00:00,1071)
(2020-08-23T17:00:00,1210)
(2020-08-24T17:00:00,953)
(2020-08-25T17:00:00,878)
(2020-08-26T17:00:00,1367)
(2020-08-27T17:00:00,1411)
(2020-08-28T17:00:00,1462)
(2020-08-29T17:00:00,1444)
(2020-08-30T17:00:00,1365)
(2020-08-31T17:00:00,996)
(2020-09-01T17:00:00,978)
(2020-09-02T17:00:00,1326)
(2020-09-03T17:00:00,1397)
(2020-09-04T17:00:00,1733)