<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic analyzing data in Data Management Questions</title>
    <link>https://community.esri.com/t5/data-management-questions/analyzing-data/m-p/144361#M8206</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Hello,&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;I have a Attribute table that has three columns In one column It states the name of well or its number next column it states the status of a program Active or Inactive and In another column I have Names of fields. My question is how do you relate the two columns or i should say analyze them. I need to count how many Active and Inactive are in each field. I figured out how to do it long way but I was wondering if anyone knows a short cut maybe somehow use one of the toolbox. below is a visual example of what i need to do. &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Thank you. &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN style="text-decoration:underline;"&gt;&lt;BR /&gt;Well name &lt;/SPAN&gt;&lt;SPAN&gt; -------&lt;/SPAN&gt;&lt;SPAN style="text-decoration:underline;"&gt;Field--&lt;/SPAN&gt;&lt;SPAN&gt;-------&lt;/SPAN&gt;&lt;SPAN style="text-decoration:underline;"&gt;Well_Status&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;.77676---------------A ------------Active&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;.5---------------------A ------------Inactive &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;.6 ---------------------A ---------------Active&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;I need a total amount of active and inactive (Is there a way to do this I have huge amount of data like this to analyze)&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN style="text-decoration:underline;"&gt;Field&lt;/SPAN&gt;&lt;SPAN&gt;------------------------&lt;/SPAN&gt;&lt;SPAN style="text-decoration:underline;"&gt;Active&lt;/SPAN&gt;&lt;SPAN&gt;--------------&lt;/SPAN&gt;&lt;SPAN style="text-decoration:underline;"&gt;Inactive&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;A------------------------------2----------------------1&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Thu, 10 Jun 2010 15:19:48 GMT</pubDate>
    <dc:creator>alexSmith1</dc:creator>
    <dc:date>2010-06-10T15:19:48Z</dc:date>
    <item>
      <title>analyzing data</title>
      <link>https://community.esri.com/t5/data-management-questions/analyzing-data/m-p/144361#M8206</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Hello,&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;I have a Attribute table that has three columns In one column It states the name of well or its number next column it states the status of a program Active or Inactive and In another column I have Names of fields. My question is how do you relate the two columns or i should say analyze them. I need to count how many Active and Inactive are in each field. I figured out how to do it long way but I was wondering if anyone knows a short cut maybe somehow use one of the toolbox. below is a visual example of what i need to do. &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Thank you. &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN style="text-decoration:underline;"&gt;&lt;BR /&gt;Well name &lt;/SPAN&gt;&lt;SPAN&gt; -------&lt;/SPAN&gt;&lt;SPAN style="text-decoration:underline;"&gt;Field--&lt;/SPAN&gt;&lt;SPAN&gt;-------&lt;/SPAN&gt;&lt;SPAN style="text-decoration:underline;"&gt;Well_Status&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;.77676---------------A ------------Active&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;.5---------------------A ------------Inactive &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;.6 ---------------------A ---------------Active&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;I need a total amount of active and inactive (Is there a way to do this I have huge amount of data like this to analyze)&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN style="text-decoration:underline;"&gt;Field&lt;/SPAN&gt;&lt;SPAN&gt;------------------------&lt;/SPAN&gt;&lt;SPAN style="text-decoration:underline;"&gt;Active&lt;/SPAN&gt;&lt;SPAN&gt;--------------&lt;/SPAN&gt;&lt;SPAN style="text-decoration:underline;"&gt;Inactive&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;A------------------------------2----------------------1&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 10 Jun 2010 15:19:48 GMT</pubDate>
      <guid>https://community.esri.com/t5/data-management-questions/analyzing-data/m-p/144361#M8206</guid>
      <dc:creator>alexSmith1</dc:creator>
      <dc:date>2010-06-10T15:19:48Z</dc:date>
    </item>
    <item>
      <title>Re: analyzing data</title>
      <link>https://community.esri.com/t5/data-management-questions/analyzing-data/m-p/144362#M8207</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Thank you for taking time to respond to me it was very helpful. But i have another question is it possible to write a code to do this in python and then just let it do the calculations or will that be challenging. &lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;thank you once again&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 10 Jun 2010 18:17:23 GMT</pubDate>
      <guid>https://community.esri.com/t5/data-management-questions/analyzing-data/m-p/144362#M8207</guid>
      <dc:creator>alexSmith1</dc:creator>
      <dc:date>2010-06-10T18:17:23Z</dc:date>
    </item>
  </channel>
</rss>

