Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

QUESTIONS A - The program provides the program design for a market, depending on the user's choice. Categories consist of Food, Cleaning and Fruits /

QUESTIONS
A- The program provides the program design for a market, depending on the user's choice. Categories consist of Food, Cleaning and Fruits/Vegetables. Determine the stock quantity and price of 5 products for each category. Calculate the payment of the products to be purchased by the customer and the remaining stock quantities using methods. Use methods with and without parameters, with and without return values. You can design the program as you wish.
Example output:
Food (1)
Cleaning Material (2)
Fruit/Vegetable (3)
Payment (4)
Exit (5)
B- Write the answers to the following questions.
1- Create a 4x4 matrix with values from 1 to 16.
2- Create a DataFrame that generates 4x3 random numbers. You can give the column and index names as you wish.
3- Arr=np.array([[50,12,np.nan,16],[np.nan, np.nan,80,70],[93,np.nan,16,np.nan]])
Convert the array of values to DataFrame. Try what can be done about missing values. (You can take the average value and write it to the missing values).
C- Download a dataset on the topic you want (from Kaggle, github or any other source).
1- Read the dataset.
2- List the first 15 data.
3- Find out how many data there are. Show the number of rows and columns.
4- Display the number 0 and 1 in the predict column (target column).
5- Display data types of all parameters.
6- Display statistical information about the data set.
7- Display missing data in dataset.
8- If there is missing data in the dataset, delete some data and show the solution to the problem
9- Find the mean of any column of numerical data in the dataset
10- Find the highest value in any column of numerical data in the dataset
11- Find the mean value by grouping them according to the column of categorical data.
12- Find how many different data are in the column consisting of categorical data.
13- Draw the correlation matrix.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Data Management Databases And Organizations

Authors: Richard T. Watson

6th Edition

1943153035, 978-1943153039

More Books

Students also viewed these Databases questions