3.3 - Actividad - Lectura Datos - Pandas.ipynb

{"nbformat":4,"nbformat_minor":0,"metadata":{"colab":{"name":"3.3 - Actividad - Lectura Datos - Pandas.ipynb","provenance":[],"collapsed_sections":[],"authorship_tag":"ABX9TyOTqYk61geEWuFOmoNt9wBM"},"kernelspec":{"name":"python3","display_name":"Python 3"}},"cells":[{"cell_type":"markdown","metadata":{"id":"SP4NFiDIvXB3"},"source":["# Actividad\n","\n","- **Nombre**: \n","- **Matrícula**: \n","\n","# Entregar \n","Archivo PDF de la actividad y la liga de la actividad en su repostitorio.\n","\n","# Nota: \n","Todas las tareas entregadas fuera de la fecha limite se califican sobre 50 de los 100 puntos posibles.\n"]},{"cell_type":"markdown","metadata":{"id":"zrQkVJYDvv_t"},"source":["1. Leer el archivo **netflix_titles.csv**\n","\n"]},{"cell_type":"code","metadata":{"id":"LN_Wc76fvY66","executionInfo":{"status":"ok","timestamp":1631489019231,"user_tz":300,"elapsed":10,"user":{"displayName":"Luz Eunice Angeles Ochoa","photoUrl":"https://lh3.googleusercontent.com/a/default-user=s64","userId":"10545729130793996561"}}},"source":[""],"execution_count":null,"outputs":[]},{"cell_type":"markdown","metadata":{"id":"ffquDfX_wihk"},"source":["2. Observa las primeras líneas usando la función head"]},{"cell_type":"code","metadata":{"id":"rsVSDf-CUpfr","executionInfo":{"status":"ok","timestamp":1631489019232,"user_tz":300,"elapsed":9,"user":{"displayName":"Luz Eunice Angeles Ochoa","photoUrl":"https://lh3.googleusercontent.com/a/default-user=s64","userId":"10545729130793996561"}}},"source":[""],"execution_count":null,"outputs":[]},{"cell_type":"markdown","metadata":{"id":"isf0Y7AgwlZT"},"source":["3. Genera una función que despliegue el primer reglon del archivo.\n"]},{"cell_type":"code","metadata":{"id":"FOtA7hjJxEH5","executionInfo":{"status":"ok","timestamp":1631489019233,"user_tz":300,"elapsed":9,"user":{"displayName":"Luz Eunice Angeles Ochoa","photoUrl":"https://lh3.googleusercontent.com/a/default-user=s64","userId":"10545729130793996561"}}},"source":["## Esta función debe de regresar una lista con los valores del primer reglon\n","def top_uno():\n","  return\n","\n","top_uno()"],"execution_count":1,"outputs":[]},{"cell_type":"markdown","metadata":{"id":"6HO4HB-yxi6u"},"source":["4. Genera una función que regrese el número de registros del archivo"]},{"cell_type":"code","metadata":{"id":"9sOQU-thxjIh","executionInfo":{"status":"ok","timestamp":1631489019233,"user_tz":300,"elapsed":9,"user":{"displayName":"Luz Eunice Angeles Ochoa","photoUrl":"https://lh3.googleusercontent.com/a/default-user=s64","userId":"10545729130793996561"}}},"source":["## Esta función tiene que entregar el número de registros del archivo\n","def row_number():\n","  return\n","\n","row_number()"],"execution_count":2,"outputs":[]},{"cell_type":"markdown","metadata":{"id":"Gt6dUOR-yWkl"},"source":["5. Generar una función que entregue las películas con release_year del 2020"]},{"cell_type":"code","metadata":{"id":"2GIB4LcryW4W","executionInfo":{"status":"ok","timestamp":1631489119597,"user_tz":300,"elapsed":296,"user":{"displayName":"Luz Eunice Angeles Ochoa","photoUrl":"https://lh3.googleusercontent.com/a/default-user=s64","userId":"10545729130793996561"}}},"source":["## Esta función tiene que entregar las películas creadas en el año 2020\n","\n","year_consulta=1\n","def released_year(year):\n","  return \n","\n","released_year(year_consulta)"],"execution_count":8,"outputs":[]},{"cell_type":"markdown","metadata":{"id":"lJe39YU9zQTt"},"source":["6. Películas con la columna de contry='Mexico'\n"]},{"cell_type":"code","metadata":{"id":"A2fk5Au1zPmI","executionInfo":{"status":"ok","timestamp":1631489147649,"user_tz":300,"elapsed":288,"user":{"displayName":"Luz Eunice Angeles Ochoa","photoUrl":"https://lh3.googleusercontent.com/a/default-user=s64","userId":"10545729130793996561"}}},"source":["## Esta función tiene que entregar las películas creadas en Mexico\n","pais_consulta='x'\n","\n","def country_year(pais_consulta):\n","  return \n","\n","country_year(pais_consulta)"],"execution_count":11,"outputs":[]}]}