Untitled
unknown
python
4 years ago
712 B
12
Indexable
import pandas as pd
from os import path
rutaFileCsv = "https://github.com/luisguillermomolero/MisionTIC2022_2/blob/master/Modulo1_Python_MisionTIC2022_Main/Semana_5/Reto/movies.csv?raw=true"
def listaPeliculas(rutaFileCsv: str) -> str:
file, ext = path.splitext(rutaFileCsv)
ext = ext.split('?')[0]
if ext == '.csv':
try:
datos = pd.read_csv(rutaFileCsv)
datos_movie = datos[['Country', 'Language', 'Gross Earnings']]
datos_salida = pd.pivot_table(datos_movie, index=['Country', 'Language'])
return datos_salida.iloc[:10,:]
except:
print('Error al leer el archivo de datos')
else:
print('Extensión inválida.')Editor is loading...