Wednesday, July 29, 2020

Importing oddly formatted txt data into stata

Hi statalist, I am dealing with precinct by precinct voting results from counties in Texas. My goal is to record elections results (how many votes each person received, who won, etc). While I currently have been just ctrl-f'ing to each precinct and aggregating the results at the end I feel like the data are formatted well enough that if I knew my stata code well enough I could easily transfer this data into a .csv or .dta format.


Here is the example of my code
Code:
0001 001 CALDWELL HTS
                                                      VOTES  PERCENT
           REGISTERED VOTERS - TOTAL .  .  .  .  .  .     0
           BALLOTS CAST - TOTAL.  .  .  .  .  .  .  .   282


          CITY OF ROUND ROCK MAYOR
          VOTE FOR  1
           PATRICK BOSE  .  .  .  .  .  .  .  .  .  .    29    11.15
           SUEANN CAMPBELL  .  .  .  .  .  .  .  .  .    46    17.69
           NYLE MAXWELL  .  .  .  .  .  .  .  .  .  .   185    71.15


          CITY OF ROUND ROCK COUNCIL, PLACE 1
          VOTE FOR  1
           RUFUS HONEYCUTT  .  .  .  .  .  .  .  .  .    84    33.07
           TED WILLIAMSON.  .  .  .  .  .  .  .  .  .    98    38.58
           SHARON IZZO.  .  .  .  .  .  .  .  .  .  .    72    28.35


          CITY OF ROUND ROCK COUNCIL, PLACE 4
          VOTE FOR  1
           CARLOS T. SALINAS.  .  .  .  .  .  .  .  .   189   100.00


          ROUND ROCK ISD TRUSTEE, PLACE 1
          VOTE FOR  1
           YVETTE SANCHEZ.  .  .  .  .  .  .  .  .  .   136    50.18
           KARLA SARTIN  .  .  .  .  .  .  .  .  .  .    43    15.87
           VIVIAN SULLIVAN  .  .  .  .  .  .  .  .  .    92    33.95


          ROUND ROCK ISD TRUSTEE, PLACE 3
          VOTE FOR  1
           PHIL DENNEY.  .  .  .  .  .  .  .  .  .  .    41    15.77
           DIANE COX  .  .  .  .  .  .  .  .  .  .  .   104    40.00
           DEBBIE BRUCE-JUHLKE .  .  .  .  .  .  .  .   115    44.23


          ROUND ROCK ISD TRUSTEE, PLACE 6
          VOTE FOR  1
           DANIEL MCFAULL.  .  .  .  .  .  .  .  .  .    76    28.90
           RAYMOND HARTFIELD.  .  .  .  .  .  .  .  .   108    41.06
           MARK MAUND .  .  .  .  .  .  .  .  .  .  .    79    30.04

PRECINCT REPORT            WILLIAMSON COUNTY, TEXAS
                           JOINT GENERAL ELECTION
                           MAY 7, 2005
RUN DATE:06/01/05 05:02 PM

          0002 002 STONY POINT
                                                      VOTES  PERCENT
           REGISTERED VOTERS - TOTAL .  .  .  .  .  .     0
           BALLOTS CAST - TOTAL.  .  .  .  .  .  .  .   338


          CITY OF ROUND ROCK MAYOR
          VOTE FOR  1
           PATRICK BOSE  .  .  .  .  .  .  .  .  .  .    26     9.52
           SUEANN CAMPBELL  .  .  .  .  .  .  .  .  .    62    22.71
           NYLE MAXWELL  .  .  .  .  .  .  .  .  .  .   185    67.77


          CITY OF ROUND ROCK COUNCIL, PLACE 1
          VOTE FOR  1
           RUFUS HONEYCUTT  .  .  .  .  .  .  .  .  .    96    36.64
           TED WILLIAMSON.  .  .  .  .  .  .  .  .  .   104    39.69
           SHARON IZZO.  .  .  .  .  .  .  .  .  .  .    62    23.66
my end game is to have all the names of candidates and their respective votes. Any advice to hasten my process and dump the manual process of looking at each outcome?

No comments:

Post a Comment