How do I format patterns data for Chicago from my pull today?


I downloaded Places, Geometry and Patterns data for Chicago today using the Shop. When I extract and open the file it appears to be oddly formatted. I have downloaded data like this before and it did not look like this. Is there something I am doing wrong? Below is a screenshot of the the csv file.

Also, I previously downloaded my data in R using the API. The reason I am thinking of re-downloading it from the Shop is that I have not yet normalized my CBG visit counts using panel data, and so I believe the only way to access panel data is through the shop now? Can someone please confirm?

Hi Angela,

It looks like Excel is splitting the multipolygon column on the embedded commas. Have you tried opening in r or stata instead?


Thanks Martin, yes it opens fine in R. Easy solution :slight_smile: