Question

23.4 Project 4: Using Pandas for data analysis and practice with error handling

Python Please!

23.4 PROJECT 4: Using Pandas for data analysis and practice with error handling Overview In this project, you will use the Pandas module to analyze some data about some 20th century car models, country of origin, miles per gallon, model year, etc. Provided Input Files An input file with nearly 200 rows of data about automobiles. The input file has the following format (the same as what you had for your chapter 13 labs). The following is an example of some of the lines in the file: mpg, cylinders,displacement, horsepower, weight, acceleration,model_year,origin, name 18,8,307,130,3504,12,70, usa, chevrolet chevelle malibu 15,8,350,165,3693,11.5,70, usa, buick skylark 320 18,8,318,150,3436,11,70, usa,plymouth satellite 16,8,304,150,3433,12,70, usa, amc rebel sst Description The first thing your program will need to do is prompt the user for a csv file name. Your prompt must be exactly Enter the filename: You will then read that csv file into a dataframe, and use that data in your analysis. If the file can not be opened, your program should not crash, but should print out the message Can't open file. Exiting program. and then exit the program. You will use a menu, like in the last project, and call several functions according to the user's menu selection You program should have a menu exactly as follows (the menu always prints a blank line first):

Answer 1

Let me know if you need any other modifications

import pandas as pd
import os

def displayMenu():
    print("(1) Get max mpg model")
    print("(2) Get min mpg model")
    print("(3) Get model year range")
    print("(4) Exit")
def get_max_mpg_model(carsdataframe, country):
    # convert the country name to lowercase.
    # just for indexing purpose that usa, USA, UsA all index the same.
    country = country.lower()
    # get a subset of the dataframe containing mpg and name for given country
    tempData = carsData[carsData['origin']==country][['mpg','name']]
    if tempData.empty:
        return "Invalid country"
    # return name at first Max mpag
    return "Best mpg model from {} is {}".format(country,tempData.loc[tempData['mpg'].idxmax(())]['name'])
def get_min_mpg_model(carsdataframe, country):
    # convert the country name to lowercase.
    # just for indexing purpose that usa, USA, UsA all index the same.
    country = country.lower()
    # get a subset of the dataframe containing mpg and name for given country
    tempData = carsData[carsData['origin']==country][['mpg','name']]
    if tempData.empty:
        return "Invalid country"
    # return name at first Max mpag
    return "Worst mpg model from {} is {}".format(country,tempData.loc[tempData['mpg'].idxmin(())]['name'])
def get_model_year_range(carsdataframe, country):
    # convert the country name to lowercase.
    # just for indexing purpose that usa, USA, UsA all index the same.
    country = country.lower()
    # get a subset of the dataframe containing only the years for given country
    tempData = carsData[carsData['origin']==country][['model_year']]
    if tempData.empty:
        return "Invalid country"
    # return min year and max year
    return "Model years range from 19{} to 19{}".format(
           tempData.loc[tempData['model_year'].idxmin(())]['model_year'],\
           tempData.loc[tempData['model_year'].idxmax(())]['model_year'])

if __name__ == "__main__":
    fileName = input("Enter the filename: ")
    # check if file exists
    if os.path.exists(fileName):
        # create a dataframe using CSV
        carsData = pd.read_csv(fileName)
        while(True):
            displayMenu()
            try:
                menuOption = int(input("Enter selection 1-4: "))
                if menuOption in range(1,4):
                    country = input("Enter the country of origin: ")
                    if menuOption == 1:
                        print(country, get_max_mpg_model(carsData, country))
                    elif menuOption == 2:
                        print(country, get_min_mpg_model(carsData, country))
                    elif menuOption == 3:
                        print(get_model_year_range(carsData, country))
                elif menuOption == 4:
                    exit(0)
                else:
                    print("Invalid selection - must be a number from 1 to 4")
            except ValueError:
                print("Invalid selection - must be a number from 1 to 4")
    else:
        print("Can't open fie. Exiting program.")

1 import pandas as pd - import os 10 11 14 16 =def displayMenu(): print("(1) Get max mpg model") print("(2) Get min mpg model") print("(3) Get model year range") print("(4) Exit") edef get_max_mpg_model(carsdataframe country) # convert the country name to lowercase. # just for indexing purpose that usa, USA, USA all index the same. country = country.lower() # get a subset of the dataframe containing mpg and name for given country tempData = carsData[carsData['origin'] =country][['mpg'n'name']] if tempData.empty: return "Invalid country" # return name at first Max mpag return "Best mpg model from {} is {}".format(country, tempData.loc[tempData['mpg'].idxmax(O)['name']) def get_min_mpg._model(carsdataframe...country # convert the country name to lowercase. # just for indexing purpose that usa, USA, USA all index the same. country = country.lower() # get a subset of the dataframe containing mpg and name for given country tempData = carsData(carsData['origin']==country][['mpg'u'name']] if tempData.empty: return "Invalid country" # return name at first Max mpag return "Worst mpg model from {} is {}".format(country tempData.loc[tempData['mpg'].idxmin( ['name']) 18 19 20 28

29 30 31 33 34 def get_model_year_range.carsdataframew.country # convert the country name to lowercase. # just for indexing purpose that usa, USA, USA all index the same. country = country.lower # get a subset of the dataframe containing only the years for given country tempData = carsData[carsData['origin']==country][['model_year']] if tempData.empty: return "Invalid country" # return min year and max year return "Model years range from 19{} to 19{}".format( tempData.loc[tempData['model_year'].idxmin( ['model_year'l tempData.loc[tempData['model_year'].idxmax( ['model_year']) 40 41

Fif_name__ == "_main ": fileName = input("Enter the filename: "); # check if file exists if os. path.exists(fileName): # create a dataframe using CSV carsData = pd. read_csv(fileName) while(True): displayMenu try: menuOption = int(input("Enter selection 1-4: ")) if menuOption in range(124): country = input("Enter the country of origin: ") if menuOption == 1: print(country, get_max_mpg_model(carsData, country)), elif menuOption == 2: print(country, get_min_mpg_model(carsData, country), elif menuOption == 3: print(get_model_year_range(carsData, country)) elif menuOption == 4: exit(0) else: print("Invalid selection - must be a number from 1 to 4") except ValueError: print("Invalid selection - must be a number from 1 to 4") else: print("Can't open fie. Exiting program.")

Enter the filename: mpg.csv (1) Get max mpg model (2) Get min mpg model (3) Get model year range (4) Exit Enter selection 1-4: 1 Enter the country of origin: usa usa Best mpg model from usa is chevrolet chevelle malibu (1) Get max mpg model (2) Get min mpg model (3) Get model year range (4) Exit Enter selection 1-4: 2. Enter the country of origin: usa usa Worst mpg model from usa is buick skylark 320, (1) Get max mpg model (2) Get min mpg model (3) Get model year range (4) Exit Enter selection 1-4: 3 Enter the country of origin: usa Model years range from 1962 to 1980 (1) Get max mpg model (2) Get min mpg model (3) Get model year range (4) Exit Enter selection 1-4: 5 Invalid selection - must be a number from 1 to 4 (1) Get max mpg model (2) Get min mpg model (3) Get model year range (4) Exit Enter selection 1-4: end Invalid selection - must be a number from 1 to 4 (1) Get max mpg model (2) Get min mpg model (3) Get model year range (4) Exit Enter selection 1-4: 4

"D:\My Apps\Python\python.exe" "B Enter the filename: sdfsdf Can't open fie. Exiting program. Process finished with exit code 0

Enter the filename: mpg.csv (1) Get max mpg model (2) Get min mpg model (3) Get model year range (4) Exit Enter selection 1-4: 1 Enter the country of origin: australia australia Invalid country (1) Get max mpg model (2) Get min mpg model (3) Get model year range (4) Exit Enter selection 1-4:

input data

- 9 LÔ - U Le cars.py mpg.csv X Plugins supporting *.csv files found. mpg,cylinders, displacement, horsepower, weight, acceleration, model_year, origin, name 18,8,307, 130,3504, 12, 70, usa, chevrolet chevelle malibu 15,8,350,165,3693, 11.5,70, usa, buick skylark 320 | 18,8,318, 150, 3436, 11, 70, usa, plymouth satellite | 146,8,304,150, 3433, 12,72, usa, amc rebel sst 184, 8, 307,130,3504, 12, 70, china, chevrolet chevelle malibu | 12,8, 350, 165,3693, 11.5,75, usa, buick skylark 320 178,8,318,150,3436,11,70, usa, plymouth satellite 16,8,304, 150,3433, 12, 62, usa, amc rebel sst 179,8,307,130,3504, 12, 80, usa, chevrolet chevelle malibu 235,8,350,165,3693, 11.5,76, japan, buick skylark 320 16,8,318,150,3436,11,70, usa, plymouth satellite 16,8,304, 150,3433, 12,72, europe, amc rebel sst 0 N CÓ KO O LÀ