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

Using python programming. Using python programming. The dataset is designed with an assumption that the

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!