Question: Using python programming. The dataset is designed with an assumption that the orders are placed by customers living in the state of Johor. The file
The dataset is designed with an assumption that the orders are placed by customers living in the state of Johor. The file has the following columns: ['Customer Name', 'Category', 'Sub Category', 'City', 'Order Date', 'District', 'Sales'] You need to write a Python program that performs the following tasks: - Reads the CSV file into a pandas DataFrame. - Allows the user to enter two search query (a string). - Searches for the query 1 is in the Category and Sub Category columns of the 1st DataFrame. - Searches for the query 2 is in the City and District columns of the 2nd DataFrame. - Prints the rows of the DataFrame where the query was found. - Your program should use the pandas library for reading the CSV file and performing the search. - It should also prompt the user to enter the search query and provide clear and informative output. Example of how the program might work is as follows
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
