data set : https://www.kaggle.com/datasets/neuromusic/avocado-prices

Code : must be written in python language under Jupyter

Q1)Read the data from the CSV file into a DataFrame.

Q2) 2) Display type, memory consumption, and null count information using the info() method. (point: 1)

Q3) Display the number of unique values in each column.

Q4) Display the first and last five rows of data and the first and last four columns of data. (point: 1)

Q5) Get the general statistics of all the numerical columns.

Q6)Multiply the Total Volume and AveragePrice columns, and store the result in a new column called EstimatedRevenue. Then, display the first five rows of this data to confirm that the column was added and has the correct values.

Q7) Create a DataFrame thats grouped by region and type and that includes the average price for the grouped columns. Then, reset the index and display the first five rows. Q8) Create a bar plot that shows the mean, median, and standard deviation of the Total Volume column by year. (point: 5)

Q9) How many unique regions are there?

Q10) What is the average price for each type of avocado (organic and conventional)? Be sure to include just the type and AveragePrice columns in the results

Q11) Which region has the lowest average price for organic avocados?

Q12) Have the Total Bags sold per year of each type of avocado become more or less consistent over time?