Add column for Imported / Local transmission

[thomasabbott]

At least at this stage, one interesting thing about the SA data is how much local transmission there has been, compared to people arriving from abroad, already infected. I could try to parse the "transmission type" column.

Could you split the "transmission type" column in data/covid19za_timeline_confirmed.csv to be
a) imported/local/unknown
b) countries visited if imported

I'm happy to do the split and PR if this makes sense

For example,

case_id,date,YYYYMMDD,country,province,geo_subdivision,age,gender,transmission_type
1,05-03-2020,20200305,South Africa,KZN,ZA-KZN,38,male,imported,Italy
2,07-03-2020,20200307,South Africa,GP,ZA-GP,39,female,imported,Italy
13,11-03-2020,20200311,South Africa,WC,ZA-WC,36,male,imported, Germany; Austria; Switzerland 
168,20-03-2020,20200320,South Africa,GP,ZA-GP,47,female,imported,pending travel history
169,20-03-2020,20200320,South Africa,GP,ZA-GP,23,male,local,

[vukosim]

There is already a csv file with the transmission types. It was seperate for another reason, but we may fuse it.

[thomasabbott]

OK.
That file isn't in good shape, but fair enough to split it out if there'll be lots of countries like that.
I'm parsing the text, seems to work for now.