Advertisement
yasi04

Maks_10

Jun 3rd, 2024 (edited)
330
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 1.57 KB | None | 0 0
  1. def remove_none_rows(data):
  2.     new_data = []
  3.     for i in range(len(data)):
  4.         if data[i][0] is not None:
  5.             new_data.append(data[i])
  6.     return new_data
  7.  
  8.  
  9. def remove_none_colums(data):
  10.     new_data = []
  11.     for i in range(len(data)):
  12.         new_data_row = []
  13.         for j in range(len(data[i])):
  14.             if data[i][j] is not None:
  15.                 new_data_row.append(data[i][j])
  16.         new_data.append(new_data_row)
  17.     return new_data
  18.  
  19.  
  20. def transform(data):
  21.     for i in range(len(data)):
  22.         data[i][0] = (f"{data[i][0].split('.')[2]}-"
  23.                       f"{data[i][0].split('.')[1]}-"
  24.                       f"{data[i][0].split('.')[0][2:]}")
  25.         data[i][1] = str(int(data[i][1].replace('%', '')) / 100)
  26.         data[i][2] = f"{data[i][2].split(' ')[0]}-{data[i][2].split(' ')[1]}"
  27.         data[i][3] = data[i][3].replace('[at]', '@')
  28.     return data
  29.  
  30.  
  31. def sorting(data):
  32.     data = list(sorted(data, key = lambda x: x[2]))
  33.     return data
  34.  
  35.  
  36. def transport(data):
  37.     new_data = [[] for _ in range(len(data[0]))]
  38.     for i in range(len(new_data)):
  39.         for j in range(len(data)):
  40.             new_data[i].append(data[j][i])
  41.     (new_data[0],
  42.      new_data[1],
  43.      new_data[2],
  44.      new_data[3]) = (new_data[0],
  45.                      new_data[1],
  46.                      new_data[2],
  47.                      new_data[3])
  48.     return new_data
  49.  
  50.  
  51. def main(data):
  52.     data = remove_none_rows(data)
  53.     data = remove_none_colums(data)
  54.     data = transform(data)
  55.     data = sorting(data)
  56.     data = transport(data)
  57.     return data
  58.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement