API/JSON Connection
<p>I am trying to connect to an API so I can grab data to use in some spatial analytics. This is my first program in Python. I have been able to connect to the API and can grab the fields i need from the resulting JSON file(s). </p>

<p>My main issue is actually combining it all together. As it stands now I have two options </p>

<ul>
<li>Generate separate arrays for each "column" i.e. an array for lat and an array for long, and then combine it into a table at the end or</li>
<li>Generate one array with all columns in it and then split by "row".</li>
</ul>

<p>The goal is to CSV this and upload to tableau. Any help would be greatly appreciated. If I haven't explained myself clearly, apologies!</p>

<p>This example code below is currently following option 2, however I am stuck at splitting by row. I can switch to option 1 by changing the data array it appends.</p>

<p>Does anyone have any suggestions or guidance?</p>

<p><a href="http://pastebin.com/EgD83UUD" rel="nofollow">http://pastebin.com/EgD83UUD</a></p>

<p>Thanks!</p>