read_data.py 1.8 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667
  1. import csv
  2. import re
  3. with open('merged.csv') as csv_file:
  4. csv_reader = csv.reader(csv_file, delimiter=',')
  5. line_count = 0
  6. durchmesser = False
  7. vorzeichen = "nix"
  8. text = True
  9. isos = []
  10. dimensions = []
  11. for row in csv_reader:
  12. line_count += 1
  13. if "ISO" in row[1]:
  14. isos.append(row[1])
  15. if durchmesser:
  16. #print("Durchmesser: " + row[1])
  17. dimensions.append("Durchmesser: " + row[1])
  18. durchmesser = False
  19. continue
  20. if row[1] == "%%c":
  21. durchmesser = True
  22. if row[1] == "-" or row[1] == "+":
  23. vorzeichen = row[1]
  24. isnumber = re.findall(r"\d*\,\d+", row[1])
  25. if isnumber:
  26. if vorzeichen != "nix":
  27. #print(vorzeichen + isnumber[0])
  28. dimensions.append(vorzeichen + isnumber[0])
  29. else:
  30. if row[1][0]!="?":
  31. #print(isnumber[0])
  32. dimensions.append(isnumber[0])
  33. vorzeichen = "nix"
  34. if row[1][0] == "?":
  35. #print("+/- " + row[1][1:])
  36. dimensions.append("+/- " + row[1][1:])
  37. print(isos)
  38. #print(dimensions)
  39. print(f'Processed {line_count} lines.')
  40. dim = []
  41. dim_count = 0
  42. for x in dimensions:
  43. if x == "Durchmesser: ":
  44. dim_count = 0
  45. if dim_count > 2:
  46. dim_count = 0
  47. if dim_count == 0:
  48. print("Maße: " + "\n" + x)
  49. dim_count += 1
  50. continue
  51. if dim_count == 1:
  52. print ("Toleranzen: " + "\n" + x)
  53. dim_count += 1
  54. if "+/-" in x:
  55. dim_count += 1
  56. continue
  57. if dim_count == 2:
  58. print(x)
  59. dim_count += 1
  60. continue