topic Re: Dataset that has multiple cities within a single cell in Spatial Data Science Questions https://community.esri.com/t5/spatial-data-science-questions/dataset-that-has-multiple-cities-within-a-single/m-p/781469#M1783 <HTML><HEAD></HEAD><BODY><P>Yes there is data in other columns that would need to be copied to the rows (with separate cities).</P><P></P><P>Thanks,</P><P></P><P></P><P>Dan Shapich | Programmer/Analyst</P><P>Global Programs</P><P>316 Boucke Building</P><P>The Pennsylvania State University</P><P>University Park, PA 16802</P><P>Email: dms139@psu.edu</P><P>Phone: 814-865-2435</P></BODY></HTML> Mon, 09 Mar 2020 18:23:27 GMT DannyShapich 2020-03-09T18:23:27Z Dataset that has multiple cities within a single cell https://community.esri.com/t5/spatial-data-science-questions/dataset-that-has-multiple-cities-within-a-single/m-p/781467#M1781 <HTML><HEAD></HEAD><BODY><P>I have a dataset that has multiple cities within a single cell (separated by pipes, colons, and commas).&nbsp; Example: Suwon;South Korea;Asia|Seoul;South Korea;Asia</P><P></P><P>What can I use to separate those cities into different rows (along with the associated data) so that ArcGIS Pro can utilize it?</P></BODY></HTML> Mon, 09 Mar 2020 17:45:22 GMT https://community.esri.com/t5/spatial-data-science-questions/dataset-that-has-multiple-cities-within-a-single/m-p/781467#M1781 DannyShapich 2020-03-09T17:45:22Z Re: Dataset that has multiple cities within a single cell https://community.esri.com/t5/spatial-data-science-questions/dataset-that-has-multiple-cities-within-a-single/m-p/781468#M1782 <HTML><HEAD></HEAD><BODY><P>are there other data associated with each row? or is that it?</P></BODY></HTML> Mon, 09 Mar 2020 18:12:55 GMT https://community.esri.com/t5/spatial-data-science-questions/dataset-that-has-multiple-cities-within-a-single/m-p/781468#M1782 DanPatterson_Retired 2020-03-09T18:12:55Z Re: Dataset that has multiple cities within a single cell https://community.esri.com/t5/spatial-data-science-questions/dataset-that-has-multiple-cities-within-a-single/m-p/781469#M1783 <HTML><HEAD></HEAD><BODY><P>Yes there is data in other columns that would need to be copied to the rows (with separate cities).</P><P></P><P>Thanks,</P><P></P><P></P><P>Dan Shapich | Programmer/Analyst</P><P>Global Programs</P><P>316 Boucke Building</P><P>The Pennsylvania State University</P><P>University Park, PA 16802</P><P>Email: dms139@psu.edu</P><P>Phone: 814-865-2435</P></BODY></HTML> Mon, 09 Mar 2020 18:23:27 GMT https://community.esri.com/t5/spatial-data-science-questions/dataset-that-has-multiple-cities-within-a-single/m-p/781469#M1783 DannyShapich 2020-03-09T18:23:27Z Re: Dataset that has multiple cities within a single cell https://community.esri.com/t5/spatial-data-science-questions/dataset-that-has-multiple-cities-within-a-single/m-p/781470#M1784 <HTML><HEAD></HEAD><BODY><P>Here is an example:</P><P></P><P>University of Leeds Leeds;United Kingdom;Europe|London;United Kingdom;Europe</P><P></P><P></P><P>I would require:</P><P></P><P>University of Leeds Leeds</P><P>University of Leeds London</P><P></P><P>I hope that helps.</P><P></P><P></P><P></P><P>Dan Shapich | Programmer/Analyst</P><P>Global Programs</P><P>316 Boucke Building</P><P>The Pennsylvania State University</P><P>University Park, PA 16802</P><P>Email: dms139@psu.edu</P><P>Phone: 814-865-2435</P></BODY></HTML> Mon, 09 Mar 2020 18:25:51 GMT https://community.esri.com/t5/spatial-data-science-questions/dataset-that-has-multiple-cities-within-a-single/m-p/781470#M1784 DannyShapich 2020-03-09T18:25:51Z Re: Dataset that has multiple cities within a single cell https://community.esri.com/t5/spatial-data-science-questions/dataset-that-has-multiple-cities-within-a-single/m-p/781471#M1785 <HTML><HEAD></HEAD><BODY><P>can you post table (dbf or gdb, csv or excel sheet) with a couple of rows.</P><P>It is easy to do with python and numpy using TableToNumPyArray and processing the array.</P><P>You have to repeat the number of cities by an unknown amount.</P><P>parsing the cities isn't a real problem, setting up the repeats needs to be tested unless you know that there will always be 2 cities, no more, no less.</P><PRE class="lia-code-sample line-numbers language-none"><CODE> a <SPAN class="operator token">=</SPAN> np<SPAN class="punctuation token">.</SPAN>asarray<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">"University of Leeds"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Leeds;United Kingdom;Europe|London;United Kingdom;Europe"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">[</SPAN>i<SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">";"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">for</SPAN> i <SPAN class="keyword token">in</SPAN> a<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"|"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Leeds'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'London'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE></BODY></HTML> Sun, 12 Dec 2021 08:50:23 GMT https://community.esri.com/t5/spatial-data-science-questions/dataset-that-has-multiple-cities-within-a-single/m-p/781471#M1785 DanPatterson_Retired 2021-12-12T08:50:23Z