This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have three separate CSV files containing data about COVID-19 infections. 1. Confirmed cases 2. Deaths and 3. Recovered cases. Each one contains country information, long and lat and a series of dates, each with a count for that day. I have to be able to combine them with totals across the time series data. This data is from JHU and it is clean, but it is not summed and combined. I have been trying to create a flow, but it is not creating the correct results. I have included the data here.
I tried creating a separate column for the totals, but that did not work. I also have the advanced join tool macro, but I need to summarize the data before I can join the files.
I hope this makes sense. The updates will be on-going so I will need to add new daily information as it becomes available.
I'm not sure if you were just looking for totals on each row or something more complicated. Attached is a workflow which will calculate the total and append it as a new column at the end of the workflow. I also took the liberty of creating a point from the lat/long. Let me know if this isn't what you were looking for...
Thank you so much for getting back to me. If I am understanding each of the flows, and please forgive my limited knowledge, this flow took each of the files summed all the dates for each country and then joined it back to the original data set. Am I correct?
The intention is to have on final file that combines each of the types of infections: confirmed, deaths and recoveries and have those summed by country.
Yes, each stream assigns a unique record id to each row, then transposes the data and updates the column "value" to a numeric value that is summarized for each record id. Those summaries are then joined to the original records.
Just a modification to the Formula tool's to write to a new column rather than modify the existing column. A little rearranging in the Select tool to get the columns in the order you provided. Good luck and Happy Alteryxing!