Learning Goal: I’m working on a python project and need support to help me learn

Learning Goal: I’m working on a python project and need support to help me learn.I have a file where I solved this using sqlite. I want the soultion to be using pandas and numpyAnswer all the questions on dessert using numpy and pandas based on the CSV file (i.e., do not use a database):a) Read the CSV file into pandas.b) Use pandas to clean the data and convert the data types to the most appropriate format:For example, the imdb_title_id resembles the following : “tt0000009”.Remove the “tt” from the value. Similarly, fields like budget, usa_gross_income,and worlwide_gross_income contain commas, dollar signs and other characters,which must be removed for the values to be stored as integers. date_publishedmust be converted to date.c) Rename the field worlwide_gross_income to worldwide_gross_income.• You may use dataframe.dtypes to verify the datatypes of your fields after conversion.d) Answer the questions by filtering and manipulating the dataframe. Do not use loops.e) Upload your finished notebook as dessert.ipynb
Requirements: follow requirements

Leave a Reply

Your email address will not be published.