fork download 
  1. >>> import csv_normal as csv
  2. >>> 
  3. >>> s = {"TOKIKAKE", "Spider-Man"}
  4. >>> 
  5. >>> d = csv.str2csv('''
  6. Title, Rate, Title en
  7. 時をかける少女, 4, TOKIKAKE
  8. トトロ, 5, TOTORO
  9. スパイダーマン, 5, Spider-Man
  10. 君の名は, 4, KIMI''')
  11. >>> 
  12. >>> d.trim()
  13. >>> d.header_idx = 0
  14. >>> d.data_row_range = slice(1, None)
  15. >>> 
  16. >>> d.print2()
  17. +--------------+----+----------+
  18. |Title         |Rate|Title en  |
  19. +--------------+----+----------+
  20. |時をかける少女|   4|TOKIKAKE  |
  21. +--------------+----+----------+
  22. |トトロ        |   5|TOTORO    |
  23. +--------------+    +----------+
  24. |スパイダーマン|   5|Spider-Man|
  25. +--------------+----+----------+
  26. |君の名は      |   4|KIMI      |
  27. +--------------+----+----------+
  28. >>> 
  29. >>> d2 = d.filter(lambda row: row[d['Title en']] not in s)
  30. >>> d2.print2()
  31. +--------+----+--------+
  32. |Title   |Rate|Title en|
  33. +--------+----+--------+
  34. |トトロ  |   5|TOTORO  |
  35. +--------+----+--------+
  36. |君の名は|   4|KIMI    |
  37. +--------+----+--------+
  38. >>> d2.csv
  39. [['Title', 'Rate', 'Title en'], ['トトロ', 5, 'TOTORO'], ['君の名は', 4, 'KIMI']]
  40. >>>
Not running #stdin #stdout 0s 0KB
comments (?)
stdin 
Standard input is empty
stdout 
Standard output is empty
https://ideone.com/rBXTZs
language:
Text (text 6.10)
created:
5 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!