Advertisement
MKbear

Python_10

May 22nd, 2022
46
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 2.21 KB | None | 0 0
  1. def delete_duplicate(table):
  2.     for row in table:
  3.         del row[5]
  4.     return table
  5.  
  6.  
  7. def delete_none(table):
  8.     new_table = []
  9.     for k in range(len(table)):
  10.         result = [i for i in table[k] if i is not None]
  11.         new_table.append(result)
  12.     table = new_table
  13.     return table
  14.  
  15.  
  16. def delete_duplicate_value(table):
  17.     new_new_table = []
  18.     for values in table:
  19.         if values not in new_new_table:
  20.             new_new_table.append(values)
  21.     table = new_new_table
  22.     return table
  23.  
  24.  
  25. def stripper(table):
  26.     for row in table:
  27.         row[0] = row[0].split('&')
  28.         row.append(row[0][0])
  29.         row.append(row[0][1])
  30.         del row[0]
  31.         row.insert(0, row.pop())
  32.         row.insert(1, row.pop())
  33.         row[0] = float(row[0])
  34.         row[0] = "{:.0%}".format(row[0])
  35.         row[0] = str(row[0])
  36.         if row[3] == '1':
  37.             row[3] = 'true'
  38.         elif row[3] == '0':
  39.             row[3] = 'false'
  40.     return table
  41.  
  42.  
  43. def new_stripper(table):
  44.     for row in table:
  45.         row[2] = row[2].split(',')
  46.         row[2].insert(0, row[2].pop())
  47.         row[2] = '.'.join(row[2])
  48.         row[2] = row[2].replace(" ", '')
  49.         row[2] = row[2][:1] + '. ' + row[2][5:]
  50.         row[1] = row[1][2:]
  51.     return table
  52.  
  53.  
  54. def main(table):
  55.     return new_stripper(
  56.         stripper(
  57.             delete_duplicate_value(
  58.                 delete_none(
  59.                     delete_duplicate(table)))))
  60.  
  61. new_data = [[None, '2001/03/05&0.33', 'Вемман, С.М.', None, '0', '0'], [None, '1999/11/08&0.35', 'Чофко, М.Ф.', None, '1', '1'], [None, '2004/09/06&0.30', 'Мавяк, А.А.', None, '1', '1'], [None, '2000/04/14&0.12', 'Боламберг, И.З.', None, '1', '1'], [None, '2001/03/05&0.33', 'Вемман, С.М.', None, '0', '0'], [None, '2001/03/05&0.33', 'Вемман, С.М.', None, '0', '0']]
  62.  
  63. data = [[None, '2001/04/25&0.42', 'Рабов, А.У.', None, '0', '0'], [None, '1999/10/04&0.07', 'Такянц, С.Ч.', None, '1', '1'], [None, '1999/10/04&0.07', 'Такянц, С.Ч.', None, '1', '1'], [None, '2004/12/12&0.82', 'Тусидли, А.Л.', None, '1', '1'], [None, '1999/10/04&0.07', 'Такянц, С.Ч.', None, '1', '1']]
  64. main(new_data)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement