NumPy ..... Pandas nothing is obvious

DanPatterson_Retired

NumPy vs Pandas

JIVE has fouled up the python syntax formatting in blogs...

hopefully this will be resolved soon

Well actually Pandas can't exist without NumPy.  But apparently it has a 'friendlier' face than its parental unit .

This demonstrates a difference.

We will begin with an array derived from a table from within ArcGIS Pro. 

I used the TableToNumPyArray

TableToNumPyArray—Data Access module | ArcGIS Desktop 

A classy function.  

The array

a <SPAN class="comment token"># ---- the array from the table ----</SPAN>

array<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">(</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'B'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'A_'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Hall'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">26</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN> <SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'C'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'C_'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Hall'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">60</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="punctuation token">(</SPAN> <SPAN class="number token">3</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'D'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'A_'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Hall'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">42</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN> <SPAN class="number token">4</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">3</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'C'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'A_'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Hall'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">57</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="punctuation token">(</SPAN> <SPAN class="number token">5</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">4</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'C'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'B_'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Hall'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">51</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN> <SPAN class="number token">6</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">5</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'B'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'B_'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Hosp'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">14</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="punctuation token">(</SPAN> <SPAN class="number token">7</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">6</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'C'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'A_'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Hall'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">45</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN> <SPAN class="number token">8</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">7</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'B'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'B_'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Hosp'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">51</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="punctuation token">(</SPAN> <SPAN class="number token">9</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">8</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'B'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'A_'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Hall'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">28</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="number token">10</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">9</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'C'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'C_'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Hosp'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">58</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="punctuation token">(</SPAN><SPAN class="number token">11</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">10</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'B'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'B_'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Hosp'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">6</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="number token">12</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">11</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'C'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'A_'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Hall'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">49</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="punctuation token">(</SPAN><SPAN class="number token">13</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">12</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'B'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'A_'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Hosp'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">42</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="number token">14</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">13</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'C'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'A_'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Hosp'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">60</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="punctuation token">(</SPAN><SPAN class="number token">15</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">14</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'C'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'B_'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Hosp'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">41</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="number token">16</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">15</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'A'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'A_'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Hosp'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">53</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="punctuation token">(</SPAN><SPAN class="number token">17</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">16</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'A'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'A_'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Hall'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">42</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="number token">18</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">17</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'A'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'C_'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Hall'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">59</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="punctuation token">(</SPAN><SPAN class="number token">19</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">18</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'C'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'C_'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Hosp'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">37</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="number token">20</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">19</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'B'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'B_'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Hall'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">52</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
 dtype<SPAN class="operator token">=</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'OBJECTID'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'<i4'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'f0'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'<i4'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'County'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'<U2'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Town'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'<U6'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Facility'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'<U8'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Time'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'<i4'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

OOOO screams the crowd in disgust... it is confusing looking.

So we will revert to the every favorite Pandas.  

<SPAN class="keyword token">import</SPAN> pandas <SPAN class="keyword token">as</SPAN> pd

pd<SPAN class="punctuation token">.</SPAN>DataFrame<SPAN class="punctuation token">(</SPAN>a<SPAN class="punctuation token">)</SPAN>

 OBJECTID f0 County Town Facility Time
<SPAN class="number token">0</SPAN> <SPAN class="number token">1</SPAN> <SPAN class="number token">0</SPAN> B A_ Hall <SPAN class="number token">26</SPAN>
<SPAN class="number token">1</SPAN> <SPAN class="number token">2</SPAN> <SPAN class="number token">1</SPAN> C C_ Hall <SPAN class="number token">60</SPAN>
<SPAN class="number token">2</SPAN> <SPAN class="number token">3</SPAN> <SPAN class="number token">2</SPAN> D A_ Hall <SPAN class="number token">42</SPAN>
<SPAN class="number token">3</SPAN> <SPAN class="number token">4</SPAN> <SPAN class="number token">3</SPAN> C A_ Hall <SPAN class="number token">57</SPAN>
<SPAN class="number token">4</SPAN> <SPAN class="number token">5</SPAN> <SPAN class="number token">4</SPAN> C B_ Hall <SPAN class="number token">51</SPAN>
<SPAN class="number token">5</SPAN> <SPAN class="number token">6</SPAN> <SPAN class="number token">5</SPAN> B B_ Hosp <SPAN class="number token">14</SPAN>
<SPAN class="number token">6</SPAN> <SPAN class="number token">7</SPAN> <SPAN class="number token">6</SPAN> C A_ Hall <SPAN class="number token">45</SPAN>
<SPAN class="number token">7</SPAN> <SPAN class="number token">8</SPAN> <SPAN class="number token">7</SPAN> B B_ Hosp <SPAN class="number token">51</SPAN>
<SPAN class="number token">8</SPAN> <SPAN class="number token">9</SPAN> <SPAN class="number token">8</SPAN> B A_ Hall <SPAN class="number token">28</SPAN>
<SPAN class="number token">9</SPAN> <SPAN class="number token">10</SPAN> <SPAN class="number token">9</SPAN> C C_ Hosp <SPAN class="number token">58</SPAN>
<SPAN class="number token">10</SPAN> <SPAN class="number token">11</SPAN> <SPAN class="number token">10</SPAN> B B_ Hosp <SPAN class="number token">6</SPAN>
<SPAN class="number token">11</SPAN> <SPAN class="number token">12</SPAN> <SPAN class="number token">11</SPAN> C A_ Hall <SPAN class="number token">49</SPAN>
<SPAN class="number token">12</SPAN> <SPAN class="number token">13</SPAN> <SPAN class="number token">12</SPAN> B A_ Hosp <SPAN class="number token">42</SPAN>
<SPAN class="number token">13</SPAN> <SPAN class="number token">14</SPAN> <SPAN class="number token">13</SPAN> C A_ Hosp <SPAN class="number token">60</SPAN>
<SPAN class="number token">14</SPAN> <SPAN class="number token">15</SPAN> <SPAN class="number token">14</SPAN> C B_ Hosp <SPAN class="number token">41</SPAN>
<SPAN class="number token">15</SPAN> <SPAN class="number token">16</SPAN> <SPAN class="number token">15</SPAN> A A_ Hosp <SPAN class="number token">53</SPAN>
<SPAN class="number token">16</SPAN> <SPAN class="number token">17</SPAN> <SPAN class="number token">16</SPAN> A A_ Hall <SPAN class="number token">42</SPAN>
<SPAN class="number token">17</SPAN> <SPAN class="number token">18</SPAN> <SPAN class="number token">17</SPAN> A C_ Hall <SPAN class="number token">59</SPAN>
<SPAN class="number token">18</SPAN> <SPAN class="number token">19</SPAN> <SPAN class="number token">18</SPAN> C C_ Hosp <SPAN class="number token">37</SPAN>
<SPAN class="number token">19</SPAN> <SPAN class="number token">20</SPAN> <SPAN class="number token">19</SPAN> B B_ Hall <SPAN class="number token">52</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

AHHHHHH the crowd cheers... much better looking.

But wait! If you just wanted the array to look pretty, you can do that with numpy and python easily as well.

How about...

id OBJECTID f0 County Town Facility Time
 <SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN>
 <SPAN class="number token">000</SPAN> <SPAN class="number token">1</SPAN> <SPAN class="number token">0</SPAN> B B_ Hall <SPAN class="number token">11</SPAN>
 <SPAN class="number token">001</SPAN> <SPAN class="number token">2</SPAN> <SPAN class="number token">1</SPAN> A A_ Hall <SPAN class="number token">24</SPAN>
 <SPAN class="number token">002</SPAN> <SPAN class="number token">3</SPAN> <SPAN class="number token">2</SPAN> C C_ Hosp <SPAN class="number token">43</SPAN>
 <SPAN class="number token">003</SPAN> <SPAN class="number token">4</SPAN> <SPAN class="number token">3</SPAN> A B_ Hall <SPAN class="number token">43</SPAN>
 <SPAN class="number token">004</SPAN> <SPAN class="number token">5</SPAN> <SPAN class="number token">4</SPAN> B B_ Hall <SPAN class="number token">16</SPAN>
 <SPAN class="number token">005</SPAN> <SPAN class="number token">6</SPAN> <SPAN class="number token">5</SPAN> B A_ Hall <SPAN class="number token">8</SPAN>
 <SPAN class="number token">006</SPAN> <SPAN class="number token">7</SPAN> <SPAN class="number token">6</SPAN> A C_ Hall <SPAN class="number token">26</SPAN>
 <SPAN class="number token">007</SPAN> <SPAN class="number token">8</SPAN> <SPAN class="number token">7</SPAN> B C_ Hall <SPAN class="number token">31</SPAN>
 <SPAN class="number token">008</SPAN> <SPAN class="number token">9</SPAN> <SPAN class="number token">8</SPAN> C C_ Hall <SPAN class="number token">7</SPAN>
 <SPAN class="number token">009</SPAN> <SPAN class="number token">10</SPAN> <SPAN class="number token">9</SPAN> A A_ Hall <SPAN class="number token">58</SPAN>
 <SPAN class="number token">010</SPAN> <SPAN class="number token">11</SPAN> <SPAN class="number token">10</SPAN> A A_ Hosp <SPAN class="number token">20</SPAN>
 <SPAN class="number token">011</SPAN> <SPAN class="number token">12</SPAN> <SPAN class="number token">11</SPAN> C A_ Hosp <SPAN class="number token">37</SPAN>
 <SPAN class="number token">012</SPAN> <SPAN class="number token">13</SPAN> <SPAN class="number token">12</SPAN> C B_ Hall <SPAN class="number token">36</SPAN>
 <SPAN class="number token">013</SPAN> <SPAN class="number token">14</SPAN> <SPAN class="number token">13</SPAN> A B_ Hosp <SPAN class="number token">33</SPAN>
 <SPAN class="number token">014</SPAN> <SPAN class="number token">15</SPAN> <SPAN class="number token">14</SPAN> C C_ Hosp <SPAN class="number token">51</SPAN>
 <SPAN class="number token">015</SPAN> <SPAN class="number token">16</SPAN> <SPAN class="number token">15</SPAN> B C_ Hosp <SPAN class="number token">53</SPAN>
 <SPAN class="number token">016</SPAN> <SPAN class="number token">17</SPAN> <SPAN class="number token">16</SPAN> C A_ Hosp <SPAN class="number token">21</SPAN>
 <SPAN class="number token">017</SPAN> <SPAN class="number token">18</SPAN> <SPAN class="number token">17</SPAN> C C_ Hosp <SPAN class="number token">42</SPAN>
 <SPAN class="number token">018</SPAN> <SPAN class="number token">19</SPAN> <SPAN class="number token">18</SPAN> A B_ Hosp <SPAN class="number token">43</SPAN>
 <SPAN class="number token">019</SPAN> <SPAN class="number token">20</SPAN> <SPAN class="number token">19</SPAN> A C_ Hall <SPAN class="number token">5</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

??????? now the crowd is confused.  Which is better? Which looks better?

The choice is yours.  Maybe I will reveal pd_ at sometime but I might rename it to dp_ in homage to its coder.

# ---- quick prints and formats

Too much?  How about a quick_prn of the array with edge items, width specification all done in a couple lines of code

quick_prn<SPAN class="punctuation token">(</SPAN>a<SPAN class="punctuation token">,</SPAN> max_lines<SPAN class="operator token">=</SPAN><SPAN class="number token">10</SPAN><SPAN class="punctuation token">)</SPAN>

Array fields<SPAN class="punctuation token">:</SPAN>
<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'OBJECTID'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'f0'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'County'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Town'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Facility'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Time'</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">(</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'B'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'A_'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Hall'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">26</SPAN><SPAN class="punctuation token">)</SPAN>
 <SPAN class="punctuation token">(</SPAN> <SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'C'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'C_'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Hall'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">60</SPAN><SPAN class="punctuation token">)</SPAN>
 <SPAN class="punctuation token">(</SPAN> <SPAN class="number token">3</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'D'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'A_'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Hall'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">42</SPAN><SPAN class="punctuation token">)</SPAN>
 <SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN>
 <SPAN class="punctuation token">(</SPAN><SPAN class="number token">18</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">17</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'A'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'C_'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Hall'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">59</SPAN><SPAN class="punctuation token">)</SPAN>
 <SPAN class="punctuation token">(</SPAN><SPAN class="number token">19</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">18</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'C'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'C_'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Hosp'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">37</SPAN><SPAN class="punctuation token">)</SPAN>
 <SPAN class="punctuation token">(</SPAN><SPAN class="number token">20</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">19</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'B'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'B_'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Hall'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">52</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

A few lines of code... a def for multiple purposes

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">quick_prn</SPAN><SPAN class="punctuation token">(</SPAN>a<SPAN class="punctuation token">,</SPAN> edgeitems<SPAN class="operator token">=</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">,</SPAN> max_lines<SPAN class="operator token">=</SPAN><SPAN class="number token">25</SPAN><SPAN class="punctuation token">,</SPAN> wdth<SPAN class="operator token">=</SPAN><SPAN class="number token">100</SPAN><SPAN class="punctuation token">,</SPAN> decimals<SPAN class="operator token">=</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN> prn<SPAN class="operator token">=</SPAN><SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
 <SPAN class="string token">"""Format a structured array by reshaping and replacing characters from
 the string representation
 """</SPAN>
 wdth <SPAN class="operator token">=</SPAN> min<SPAN class="punctuation token">(</SPAN>len<SPAN class="punctuation token">(</SPAN>str<SPAN class="punctuation token">(</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="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> wdth<SPAN class="punctuation token">)</SPAN>
 <SPAN class="keyword token">with</SPAN> np<SPAN class="punctuation token">.</SPAN>printoptions<SPAN class="punctuation token">(</SPAN>precision<SPAN class="operator token">=</SPAN>decimals<SPAN class="punctuation token">,</SPAN> edgeitems<SPAN class="operator token">=</SPAN>edgeitems<SPAN class="punctuation token">,</SPAN>
 threshold<SPAN class="operator token">=</SPAN>max_lines<SPAN class="punctuation token">,</SPAN> linewidth<SPAN class="operator token">=</SPAN>wdth<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
 <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"\nArray fields:\n{}\n{}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>a<SPAN class="punctuation token">.</SPAN>dtype<SPAN class="punctuation token">.</SPAN>names<SPAN class="punctuation token">,</SPAN> a<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

---- Analysis? ----

What about pivot tables? Excel has them, so does Pandas.  A quick call to some small python/numpy defs and...

Can't do the blue bit though.

---- Comment -----

Of course this blog is purely in jest, but it serves to point out that not is all that it seems and that everything has a root.  Remember your origins, even if that means in coding.

DanPatterson_Retired

I would be remiss if I didn't comment that recarrays/structured arrays can look a bit confusing, but for quick formatting, you can just use np.set_printoptions to change the appearance.  Here a 60,000 ish dataset that  Joe Borgione i‌s referring to...

x <SPAN class="operator token">=</SPAN> a<SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="number token">10</SPAN><SPAN class="punctuation token">]</SPAN>&nbsp; <SPAN class="comment token"># ----- slice 10 records from 60K records</SPAN>

x&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># ---- admittedly, doesn't look friendly</SPAN>

array<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">(</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'N A ST'</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">49</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN> <SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'N A ST'</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">50</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp;&nbsp; <SPAN class="number token">450</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">(</SPAN> <SPAN class="number token">3</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'S AARON WY'</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; <SPAN class="number token">4775</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; <SPAN class="number token">4865</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN> <SPAN class="number token">4</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'W AARON PARK CIR'</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; <SPAN class="number token">1020</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; <SPAN class="number token">1077</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">(</SPAN> <SPAN class="number token">5</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'E ABBEDALE LN'</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; <SPAN class="number token">1700</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; <SPAN class="number token">1849</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN> <SPAN class="number token">6</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'S ABBY CT'</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; <SPAN class="number token">4295</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; <SPAN class="number token">4321</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">(</SPAN> <SPAN class="number token">7</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'S ABBEY BEND LN'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">14324</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">14512</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN> <SPAN class="number token">8</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'W ABBEY BEND LN'</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; <SPAN class="number token">4235</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; <SPAN class="number token">4300</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">(</SPAN> <SPAN class="number token">9</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'S ABBEY GLEN WY'</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; <SPAN class="number token">3211</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; <SPAN class="number token">3309</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="number token">10</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'S ABBEY GLEN WY'</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; <SPAN class="number token">3310</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; <SPAN class="number token">3385</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; dtype<SPAN class="operator token">=</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'OBJECTID'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'<i4'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'FULLNAME'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'<U214'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'STR2_LOW_RANGE'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'<i4'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'STR2_HIGH_RANGE'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'<i4'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>x<SPAN class="punctuation token">)</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># ---- print doesn't add much</SPAN>

<SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">(</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'N A ST'</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">49</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">(</SPAN> <SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'N A ST'</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">50</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp;&nbsp; <SPAN class="number token">450</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">(</SPAN> <SPAN class="number token">3</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'S AARON WY'</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; <SPAN class="number token">4775</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; <SPAN class="number token">4865</SPAN><SPAN class="punctuation token">)</SPAN>
 <SPAN class="punctuation token">(</SPAN> <SPAN class="number token">4</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'W AARON PARK CIR'</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; <SPAN class="number token">1020</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; <SPAN class="number token">1077</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">(</SPAN> <SPAN class="number token">5</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'E ABBEDALE LN'</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; <SPAN class="number token">1700</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; <SPAN class="number token">1849</SPAN><SPAN class="punctuation token">)</SPAN>
 <SPAN class="punctuation token">(</SPAN> <SPAN class="number token">6</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'S ABBY CT'</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; <SPAN class="number token">4295</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; <SPAN class="number token">4321</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">(</SPAN> <SPAN class="number token">7</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'S ABBEY BEND LN'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">14324</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">14512</SPAN><SPAN class="punctuation token">)</SPAN>
 <SPAN class="punctuation token">(</SPAN> <SPAN class="number token">8</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'W ABBEY BEND LN'</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; <SPAN class="number token">4235</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; <SPAN class="number token">4300</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">(</SPAN> <SPAN class="number token">9</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'S ABBEY GLEN WY'</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; <SPAN class="number token">3211</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; <SPAN class="number token">3309</SPAN><SPAN class="punctuation token">)</SPAN>
 <SPAN class="punctuation token">(</SPAN><SPAN class="number token">10</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'S ABBEY GLEN WY'</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; <SPAN class="number token">3310</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; <SPAN class="number token">3385</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="comment token"># ---- Now set the printoptions to restrict the linewidth to 30 before it wraps</SPAN>

np<SPAN class="punctuation token">.</SPAN>set_printoptions<SPAN class="punctuation token">(</SPAN>edgeitems<SPAN class="operator token">=</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">,</SPAN> linewidth<SPAN class="operator token">=</SPAN><SPAN class="number token">30</SPAN><SPAN class="punctuation token">,</SPAN> threshold<SPAN class="operator token">=</SPAN><SPAN class="number token">20</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>x<SPAN class="punctuation token">)</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># ---- looks pretty okish</SPAN>
<SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">(</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'N A ST'</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">49</SPAN><SPAN class="punctuation token">)</SPAN>
 <SPAN class="punctuation token">(</SPAN> <SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'N A ST'</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">50</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp;&nbsp; <SPAN class="number token">450</SPAN><SPAN class="punctuation token">)</SPAN>
 <SPAN class="punctuation token">(</SPAN> <SPAN class="number token">3</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'S AARON WY'</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; <SPAN class="number token">4775</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; <SPAN class="number token">4865</SPAN><SPAN class="punctuation token">)</SPAN>
 <SPAN class="punctuation token">(</SPAN> <SPAN class="number token">4</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'W AARON PARK CIR'</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; <SPAN class="number token">1020</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; <SPAN class="number token">1077</SPAN><SPAN class="punctuation token">)</SPAN>
 <SPAN class="punctuation token">(</SPAN> <SPAN class="number token">5</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'E ABBEDALE LN'</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; <SPAN class="number token">1700</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; <SPAN class="number token">1849</SPAN><SPAN class="punctuation token">)</SPAN>
 <SPAN class="punctuation token">(</SPAN> <SPAN class="number token">6</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'S ABBY CT'</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; <SPAN class="number token">4295</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; <SPAN class="number token">4321</SPAN><SPAN class="punctuation token">)</SPAN>
 <SPAN class="punctuation token">(</SPAN> <SPAN class="number token">7</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'S ABBEY BEND LN'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">14324</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">14512</SPAN><SPAN class="punctuation token">)</SPAN>
 <SPAN class="punctuation token">(</SPAN> <SPAN class="number token">8</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'W ABBEY BEND LN'</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; <SPAN class="number token">4235</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; <SPAN class="number token">4300</SPAN><SPAN class="punctuation token">)</SPAN>
 <SPAN class="punctuation token">(</SPAN> <SPAN class="number token">9</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'S ABBEY GLEN WY'</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; <SPAN class="number token">3211</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; <SPAN class="number token">3309</SPAN><SPAN class="punctuation token">)</SPAN>
 <SPAN class="punctuation token">(</SPAN><SPAN class="number token">10</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'S ABBEY GLEN WY'</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; <SPAN class="number token">3310</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; <SPAN class="number token">3385</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="comment token"># ---- to many rows???? set the threshold to some value before .... cuts in</SPAN>

<SPAN class="comment token">#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Note the edgeitems restricts this to the first and last 3 entries of the array</SPAN>

np<SPAN class="punctuation token">.</SPAN>set_printoptions<SPAN class="punctuation token">(</SPAN>edgeitems<SPAN class="operator token">=</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">,</SPAN> linewidth<SPAN class="operator token">=</SPAN><SPAN class="number token">30</SPAN><SPAN class="punctuation token">,</SPAN> threshold<SPAN class="operator token">=</SPAN><SPAN class="number token">9</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>x<SPAN class="punctuation token">)</SPAN>
<SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">(</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'N A ST'</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp;&nbsp; <SPAN class="number token">49</SPAN><SPAN class="punctuation token">)</SPAN>
 <SPAN class="punctuation token">(</SPAN> <SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'N A ST'</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp;&nbsp; <SPAN class="number token">50</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; <SPAN class="number token">450</SPAN><SPAN class="punctuation token">)</SPAN>
 <SPAN class="punctuation token">(</SPAN> <SPAN class="number token">3</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'S AARON WY'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">4775</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">4865</SPAN><SPAN class="punctuation token">)</SPAN>
 <SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN>
 <SPAN class="punctuation token">(</SPAN> <SPAN class="number token">8</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'W ABBEY BEND LN'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">4235</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">4300</SPAN><SPAN class="punctuation token">)</SPAN>
 <SPAN class="punctuation token">(</SPAN> <SPAN class="number token">9</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'S ABBEY GLEN WY'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">3211</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">3309</SPAN><SPAN class="punctuation token">)</SPAN>
 <SPAN class="punctuation token">(</SPAN><SPAN class="number token">10</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'S ABBEY GLEN WY'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">3310</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">3385</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN>


<SPAN class="comment token"># ---- But I still like mine better</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>