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

[Angela_Rout_UBC]

Hello,

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?

[Martin_Andersen_UNC_Greensboro]

Hi Angela,

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

Martin

[Angela_Rout_UBC]

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