Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- def remove_none_rows(data):
- new_data = []
- for i in range(len(data)):
- if data[i][0] is not None:
- new_data.append(data[i])
- return new_data
- def remove_none_colums(data):
- new_data = []
- for i in range(len(data)):
- new_data_row = []
- for j in range(len(data[i])):
- if data[i][j] is not None:
- new_data_row.append(data[i][j])
- new_data.append(new_data_row)
- return new_data
- def transform(data):
- for i in range(len(data)):
- data[i][0] = (f"{data[i][0].split('.')[2]}-"
- f"{data[i][0].split('.')[1]}-"
- f"{data[i][0].split('.')[0][2:]}")
- data[i][1] = str(int(data[i][1].replace('%', '')) / 100)
- data[i][2] = f"{data[i][2].split(' ')[0]}-{data[i][2].split(' ')[1]}"
- data[i][3] = data[i][3].replace('[at]', '@')
- return data
- def sorting(data):
- data = list(sorted(data, key = lambda x: x[2]))
- return data
- def transport(data):
- new_data = [[] for _ in range(len(data[0]))]
- for i in range(len(new_data)):
- for j in range(len(data)):
- new_data[i].append(data[j][i])
- (new_data[0],
- new_data[1],
- new_data[2],
- new_data[3]) = (new_data[0],
- new_data[1],
- new_data[2],
- new_data[3])
- return new_data
- def main(data):
- data = remove_none_rows(data)
- data = remove_none_colums(data)
- data = transform(data)
- data = sorting(data)
- data = transport(data)
- return data
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement