Advertisement
Guest User

Untitled

a guest
Apr 26th, 2018
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.69 KB | None | 0 0
  1. path1 = 'zadanie2.csv'
  2. path2 = 'zadanie2_.csv'
  3. lines = open(path1).read().splitlines()
  4.  
  5. new_lines = []
  6. for i, line in enumerate(lines):
  7.     if i > 0:
  8.         kek = line.split(',')
  9.  
  10.         key = int(kek[0].strip())
  11.         value = kek[1]
  12.  
  13.         if kek[1] != '':
  14.             new_lines.append([key, value])
  15.  
  16.  
  17. new_lines_sorted = sorted(new_lines, key=lambda x: x[0])
  18.  
  19. prev = 0
  20. for x in new_lines_sorted:
  21.     while x[0] <= prev:
  22.         x[0] += 1
  23.     prev = x[0]
  24.  
  25.  
  26.  
  27. new_lines_sorted_merged = []
  28. for x in new_lines_sorted:
  29.     new_lines_sorted_merged.append(str(x[0]) + ',' + x[1])
  30.  
  31. print(new_lines_sorted_merged)
  32.  
  33. open(path2, 'w').write('\n'.join(new_lines_sorted_merged))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement