Advertisement
Guest User

Untitled

a guest
Feb 27th, 2015
185
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.67 KB | None | 0 0
  1. import pandas
  2.  
  3. require_list = []
  4. with open('require.csv') as fo:
  5. for line in fo:
  6. require_list.append(line.strip())
  7.  
  8. #Then I see,
  9. id
  10. cat
  11. elephant
  12. dog # I have elephant in my list.
  13.  
  14. data = pandas.read_csv("require_database.csv")
  15.  
  16. id kg
  17. 0 squirrel 0.1
  18. 1 horse 80
  19. 2 cat 7
  20. 3 bee 0.03
  21. 4 dog 12
  22. 5 goldfish 0.08 # Unfortunately I do not have data for elephant.
  23.  
  24. data_list = data[data['id'].isin(require_list)]
  25. print data_list
  26.  
  27. # I'd like to get something like below....
  28. id kg
  29. cat 7
  30. elephant null # Add "null" behind the elephant..
  31. dog 12 # Order is the same as my given list.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement