Create six TIME SERIES(USING pd.series function) and store in a Pandas data frame: a)The data frame must have an index that is a range of dates from 2016-01-01 until today. b)Each column contains one set of random numbers in a range 0 to 1 (each column will haveone random number for each date). number of columns = 6  number of rows = date range between today and 2016-01-01

PROBLEM 2: Save your file as Surname_Pandas-P2.py Using the dataframe cars in problem 1, extract the following information using subsetting, slicing and indexing operations. a. Display the first five rows with odd-numbered columns (columns 1, 3, 5, 7...) of cars. b. Display the row that contains the 'Model' of 'Mazda RX4'. C. How many cylinders ('cyl') does the car model 'Camaro Z28' have? d. Determine how many cylinders ('cyl') and what gear type ('gear') do the car models 'Mazda RX4 Wag', 'Ford Pantera L' and 'Honda Civic' have.

R7

Using R lab please provide the code and answer:Find the data set “HELPrct”. Construct a side by side boxplots (can be horizontal orvertical) to compare the effect of homeless or housed on the average number of drinks perday for the patients. Add title “XXXXXX – Side by side Boxplot to compare the effect ofhomeless on average number ofDrinks”.Based on the side by side boxplot; write a simple conclusion.Find the data set “HELPrct”. Construct a side by side boxplots (can be horizontal orvertical) to compare the effect of different race groups on the average number of drinksper day for the patients. Add title “XXXXXX – Side by side Boxplot to compare the effectof race groups vs on averagenumber of Drinks”.Based on the side by side boxplot; write a simple conclusion.

Language - Python

Using the data file below design a hierarchical struct to organize the data. Then declare an array of structs for the reservations.  The data file contains ten reservations. There are 8 columns of data: party name, size, date and time for the reservation, phone number, email address, credit card number and expiration date for the credit card. The data can be read from the file below so you will not need to type it in repeatedly.  Once you have populated the array with data perform the following tasks: Write a function that will print out to the screen the information for one reservation.In the main program write code that prompts the user to enter a date in the form MM DD YYYYCall the function to print out all reservations on that date. You can make a loop that calls the print function repeatedly or you can put that code inside the print function.TEST CASES:  April 30, 2023 and May 12, 2023. In this example you need to carefully consider what data types to use. For example, the credit…

What code do i need to use to delete the first column

The flights data set contains information about each flight in 2013. The planes data set contains information about each airplane. a) Which variable would be the key for combining the two data frames using one of the *_join() functions? b) Combine the flights and planes data sets using an appropriate *_join() func- tion. Which manufacturer made the most flights in 2013? How many flights did it make?

What function in the pandas library can display the maximum rows or columns in a table? A) pd.set_table B) pd.read_csv C) pd.set_data D pd.set_option

This is Pandas Which of the following would be a correct way to return rows 0 through 5 of columns "Name" and "Age" from the data frame df?   df.loc[0:5, ["Name", "Age"]]   df.loc[:5, "Name", "Age"]   df.loc[0:6, ["Name", "Age"]]   df.loc[:6, "Name", "Age"]