Question

PYTHON:

From this list:

lista=[['Harry_Potter 1 2345 0 1', 'The_Matrix 1 034X 4 1', 'Black_mirror 0 45XX 3 1', 'Avenger 1 04XX 2 1', 'Cinderella 1 36XX 0 1', 'Snow_white 1 36XX 0 1', 'Rapunzel 1 36XX 0 1', 'Anne_with_an_E 0 24XX 0 0', 'Invented 0 1267 1 0', 'Invented2 1 67XX 4 1']

How do I create a function that return the table below with for/while loops (excluding the movie type genre....row):

I tried to use for loop to extract each category into a list but I cannot locate the element after the movie name (e.g: 1 for Harry_Potter, 1 for The_Matrix, 0 for Black_mirror...)

Any help would be appreciated. Thank you!

type rating origin 4, 5] 4] movie Harry_Potter The_Matrix Black_mirror Avenger Cinderella Snow_white Rapunzel Anne_with_an_E Invented Invented2 genres [2, 3, [0, 3, [4, 5] [0, 4] [3, POOPPPPOPP [3, 6] [2, [1, [6, 4] 2, 7] 6, 7]

Answer 1

V OPEN EDITORS rangoli by X sample.py V HCKRRANK rangoli.py sample.py sample by import pandas as pd def table(lista): movie=U] types=[] genres=[] rating=[] origin=[] for row in lista. row_split= row.split(' ') genres_cell=[] movie.append(row_split[@]) types.append(int (row_split[1)) for genre in row_split[2] : if genre.isdigit(): genres_cell.append(int(genre)); genres.append(genres_cell) rating.append(int(row_split[3])), origin.append(int (row_split(41)) = pd. DataFrame({ 'movie':movie, 'type':types, 'genres':genres, "rating":rating, 'origin':origin 3) return df 31 table(lista) QUTLINE