Jump to content

PatrickPetersen

Members
 View Profile  See their activity

  • Posts

    10

  • Joined

  • Last visited

PatrickPetersen's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. PatrickPetersen
    Oh god! It works! You just saved my thesis ! thank you SO much!!
  2. PatrickPetersen
    Nope the column street is a consolidation of zip code city street name street number And the status column is 12 or 13 different statuses. Usually I would think the address could have been a unique, but when I randomly made a check for duplicates I found that 5% of the full data set contained duplicates. That's why I need a conditional deletion.
  3. PatrickPetersen
    Unfortunately, that's not enough.. It needs to weigh the value.. Not all duplicates have for example unknown as a status. It needs to meet the conditions in the array. If the same address from the example before had Ready in the first and not relevant, it should delete the not relevant entry because ready is higher than not relevant
  4. PatrickPetersen
    It's not only in lines with special chars
  5. PatrickPetersen
    You're thinking about the file permission right? I've checked all boxes just in case..(CHMod 777) but it still gives the same.. A case from the csv/txt-file: 2300 København S Englandsvej 160;Not possible/Project delayed; 2300 København S Englandsvej 160;Unknown; It should remove "2300 København S Englandsvej 160;Unknown;" and keep "2300 København S Englandsvej 160;Not possible/Project delayed;"
  6. PatrickPetersen
    It makes a file on my server, but the data seems unchanged You can see my input.csv at http://thesis.mesmerize.dk/input.csv and after you have run the script at http://thesis.mesmerize.dk/input.php you get the output at http://thesis.mesmerize.dk/output.csv
  7. PatrickPetersen
    Cool! I've tried that now and it writes.. Just give me 2 minuttes and I'll run it
  8. PatrickPetersen
    This works! Now to a more difficult part.. I have made a "ranking" of the status' (Which status weighs more than the other) How can it be implementet? My ranking is: Ready Possible BBU - Possible Pipe ready BBU - Pipe ready Established Waiting for planning Study Not possible/Project delayed Not possible Not relevant Unknown BBU - Unknown It's for my bachelor thesis so I really do appreciate your help!
  9. PatrickPetersen
    Hi - Maybe I'm just getting stupid as fuck as the time goes by.. But isn't that more of a call to the sql database? (haven't done csv-databases before making this survey)
  10. PatrickPetersen
    Hello - First of all, I have low->medium knowledge of php, but it hasn't been used for allmost 10 years - But I'm all stuck here! I hope someone can help me, I'm pretty sure I will be getting retarded soon.. I have a CSV-file that has a structure like this: street, status, project Road Street 2, Possible, HyperGalaxy Street Road 4, Ready, Galaxy Road Street 2, Unknown, Unkown I've tried to import it into excel and making a macro, but after 3-5 hours of processing, my computer crashes and I have to start all over. My goal is that "Road Street 2, Unknown, Unknown" is deleted because of the status. - Possible is "better" than unknown - in this case.. I have around 300.000 rows and I know there will be approx. 10.000 duplicated values (and therefore 5.000 unique) Are there any way of deleting duplicates by a "condition"?
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.