Storing tabular data as pandas dataframe: Data preprocessing is one of the steps in machine learning. The pandas library in python is suitable to deal with tabular data. Create a variable ‘emissions’ and assign to it the following data (Table 1) as padas DataFrame. Create an excel file ‘emissions_from_pandas.xlsx’ from the ‘emissions’ variable using python. Table 1. Particulate matter (PM) emissions (in g/gal) for 15 vehicles driven at low altitude and another 15 vehicles driven at high altitude. Low Altitude High Altitude 1.50 7.59 1.48 2.06 2.98 8.86 1.40 8.67 3.12 5.61 0.25 6.28 6.73 4.04 5.30 4.40 9.30 9.52 6.96 1.50 7.21 6.07 0.87 17.11 1.06 3.57 7.39 2.68 1.37 6.46   iloc[] method: (b) Using the .iloc[] method, we can access any part of the dataframe. Run the following commands and show the outputs: emissions.head() emissions.iloc[0,0] emissions.iloc[1,1] emissions.iloc[0:2,0:2] emissions.iloc[2:4,:]

Computer Science Objective: To create a JSON for Population census with objects and arrays   Scenario: ABC Census Company is maintaining database on the survey taken.   Application sends the details of schemes in the form of JSON Help to create a JSON with the information provided.   Name Datatype of value Country String State String YearOfSurvey Number TotalPopulation String AgeGroup Object   AgeGroup- Object :    Name Datatype of value 0-14 Array 15-24 Array 25-44 Array 45-64 Array Above65 Array Array :    Name Datatype of value male Number female Number You can assume any data for the mentioned JSON structure, provided it is matching the specified datatype

GDB and Getopt Class Activity activity [-r] -b bval value Required Modify the activity program from last week with the usage shown. The value for bval is required to be an integer as is the value at the end. In addition, there should only be one value. Since everything on the command line is read in as a string, these now need to be converted to numbers. You can use the function atoi() to do that conversion. You can do the conversion in the switch or you can do it at the end of the program. The number coming in as bval and the value should be added together to get a total. That should be the only value printed out at the end. Total = x should be the only output from the program upon success. Remove all the other print statements after testing is complete. Take a screenshot of the output to paste into a Word document and submit. Practice Compile the program with the -g option to load the symbol table. Run the program using gdb and use watch on the result so the program stops when the…

using python in jupyter notebook; we were given a csv file called stolen_animals.csv which contained data on stolen animals in london . The original raw data was given like this; Count of Stolen Animals,Type of Animal,Borough,Type Of Offence,Animal Recovered,Year and Month1,Dog,Lambeth,Theft and Handling,Not Recovered,Jan-20101,Dog,Islington,Violence Against the Person,Not Recovered,Jan-2010 but have written a function which made each column into list, count of stolen animals into a list of integers and the rest into list of integers. I now need to create functions to find the average number of stolen animals and another to get a list of unique types of animals that have been stolen. To add we are not allowed to use packages and can only input/output to be done by open and close. Below is the specifications given for each function