firstTwoInsights

import pandas as pd
import matplotlib.pyplot as plt
xl = pd.ExcelFile("SalesDataFull.xlsx")
OrdersOnlyData = xl.parse("Orders")
lines = "="*25

while True:
    print("\nView Products by Month - press 1. View Product by Quarter - press 2.")
    user_decision = input("Which type of data would you like to access? ")

    while user_decision == "":
        user_decision = input("Which type of data would you like to access? ")

    if user_decision == "1":
        print()
        print("Profit by Month")
        print("View 10 Most Popular Products - press 1. View 10 Least Popular Products - press 2. ")
        month_choice = input("Which type of data do you like access to? ")

        while month_choice == "":
            month_choice = input("Which type of data would you like to access? ")

        if month_choice == "1":
            df_month = OrdersOnlyData["Order Date"].dt.month
            OrdersOnlyData["Month"] = df_month
            product_sales = OrdersOnlyData[["Product Name", "Month", "Profit"]]
            product_sales_sum = product_sales.groupby(by="Month" and "Product Name").sum().sort_values(by=["Profit"], ascending=False)
            product_sales_sum = product_sales.reset_index()
            print(product_sales_sum.head(10).round(2))
            plt.figure(figsize=(6, 6))
            plt.title("Profit by Month")
            plt.axis("equal")
            plt.pie(product_sales_sum.Profit, labels=product_sales_sum.Month)
            plt.show()
            exit_program = input("Exit Program? (Y/N): ")
            if exit_program.casefold() == "Y":
                print("Goodbye!")
                break

        if month_choice == "2":
            df_month = OrdersOnlyData["Order Date"].dt.month
            OrdersOnlyData["Month"] = df_month
            product_sales = OrdersOnlyData["Product Name", "Month" "Profit"]
            product_sales_sum = product_sales.groupby(by="Month" and "Product Name").sum().sort_values(by=["Profit"], ascending=False)
            product_sales_sum = product_sales.reset_index()
            print(product_sales_sum.tail(10).round(2))
            year = input("Do you want to see data by the year? ")
            if year.casefold() == "y":
                orders2014 = OrdersOnlyData.loc[OrdersOnlyData["Order Date"] > "2014-01-01"]
                print(orders2014.head(10).round(2))
            exit_program = input("Exit Program? (Y/N): ")
            if exit_program.casefold() == "Y":
                print("Goodbye!")
                break

    if user_decision == "2":
        print("Profit by Quarter.")
        quarter_choice = input("View 10 Most Popular Products - press 1. View 10 Least Popular Products - press 2.")

        while quarter_choice == "":
            quarter_choice = input("View 10 Most Popular Products - press 1. View 10 Least Popular Products - press 2.")

        if quarter_choice == "1":
            df_quarter = OrdersOnlyData["Order Data"].dt.quarter
            OrdersOnlyData["Quarter"] = df_quarter
            product_sales = OrdersOnlyData[["Product Name", "Quarter", "Profit"]]
            product_sales_sum = product_sales.groupby(by="Quarter" and "Product Name").sum().sort_values(by=["Profit"], ascending=False)
            product_sales_sum = product_sales.reset_index()
            print(product_sales_sum.head(10).round(2))
            exit_program = input("Exit Program? (Y/N): ")
            if exit_program.casefold() == "Y":
                print("Goodbye!")
                break

        if quarter_choice == "2":
            df_quarter = OrdersOnlyData["Order Data"].dt.quarter
            OrdersOnlyData["Quarter"] = df_quarter
            product_sales = OrdersOnlyData["Product Name", "Quarter", "Profit"]
            product_sales_sum = product_sales.groupby(by="Quarter" and "Product Name").sum().sort_values(by=["Profit"], ascending=False)
            product_sales_sum = product_sales.reset_index()
            print(product_sales_sum.tail(10).round(2))
            exit_program = input("Exit Program? (Y/N): ")
            if exit_program.casefold() == "Y":
                print("Goodbye!")
                break