Buying I need a very large CSV file parsed/filtered $30

Discussion in 'Services' started by aidanriley629, May 12, 2016.

0
  1. #1
    I have a CSV file that's about 5gb (yes GB). I need it filtered to my specifications and new files to be made out of the results of the filtered search. If that makes sense. Everyone I've asked so far has been unable to work with a CSV that large. paying $30.
     
    aidanriley629, May 12, 2016 IP
  2. aidanriley629

    aidanriley629 Banned

    Messages:
    429
    Likes Received:
    23
    Best Answers:
    3
    Trophy Points:
    175
    As Seller:
    100% - 0
    As Buyer:
    100% - 3
    #2
    I still need this done. Offering $50.

    Details:
    Download this zip file.
    http://download.cms.gov/nppes/NPPES_Data_Dissemination_May_2016.zip
    Extract it.

    Write a script to filter the CSV data as followed:

    First, select only the rows which contain one of the following:
    DEA
    DEA NUMBER
    FEDERAL DEA
    DEA #
    DEA#
    DEA REGISTRATION
    Save those rows into an excel spreadsheet called all_DEA.xls

    Next, out of the new file, select only the entries whose designation is:
    MD
    M.D.
    DO
    D.O.
    PA
    P.A.
    PA-C
    P.A.-C.
    NP
    N.P.
    FNP
    F.N.P.
    Save new file as DEA_and_provider.xls

    Next, out of the new file, save each state individually into 50 separate files divded by state, titled with the two letter state abbreviation (CA, OR, LA, MO etc).

    CA.xls
    MO.xls
    NV.xls
    etc.

    Zip them all and send a screenshot or other proof.

    If successful, send a paypal invoice to:

    Thanks
     
    aidanriley629, May 12, 2016 IP
  3. dastagiri

    dastagiri Well-Known Member

    Messages:
    69
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    108
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #3
    Already started, sending you soon..thanks
     
    dastagiri, May 12, 2016 IP
  4. aidanriley629

    aidanriley629 Banned

    Messages:
    429
    Likes Received:
    23
    Best Answers:
    3
    Trophy Points:
    175
    As Seller:
    100% - 0
    As Buyer:
    100% - 3
    #4
    so far no one has delivered. raising price to 75$
     
    aidanriley629, May 13, 2016 IP
    puregreen likes this.
  5. maestria

    maestria Well-Known Member

    Messages:
    705
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    110
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #5
    is the task still available?
     
    maestria, May 16, 2016 IP
  6. O-D-T

    O-D-T Member

    Messages:
    180
    Likes Received:
    10
    Best Answers:
    3
    Trophy Points:
    43
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #6
    Note that all the rules except for the first one in this part of the assignment are reduntand as they all contain "DEA", is that what you wanted?

    Anyway, if .XLS on the output might be to heavy. Would you mind .CSV on the ouput?
     
    O-D-T, May 16, 2016 IP
  7. sarahk

    sarahk iTamer Staff

    Messages:
    28,841
    Likes Received:
    4,542
    Best Answers:
    123
    Trophy Points:
    665
    As Seller:
    100% - 0
    As Buyer:
    100% - 2
    #7
    The work has been done, delivered and paid for however the payment is now subject to a dispute at PayPal.
     
    sarahk, May 23, 2016 IP