2.1Write a python program to create appropriate data structure with 10 random data points. You are working for a car dealership. They want to use a Python script to manage and update their inventory. They sell Cars, Trucks, and SUVs. Each vehicle has at least the following attributes: id, model, production year, mileage, capacity, and color. Design a schema for how you would organize these in Python. 2.2Write a python code to groupby cars based on colors and give the average of milage. Show the number of cars, trucks and SUV's.

2.1Write a python program to create appropriate data structure with 10 random data points. You are working for a car dealership. They want to use a Python script to manage and update their inventory. They sell Cars, Trucks, and SUVs. Each vehicle has at least the following attributes: id, model, production year, mileage, capacity, and color. Design a schema for how you would organize these in Python. 2.2Write a python code to groupby cars based on colors and give the average of milage. Show the number of cars, trucks and SUV's.

Systems Architecture

7th Edition

ISBN:9781305080195

Author:Stephen D. Burd

Publisher:Stephen D. Burd

Chapter3: Data Representation

Section: Chapter Questions

Problem 3RP

See similar textbooks

Similar questions

TASK 2 Design a database to store student personal details, module details, and assessment results for the students taking the Data Management degree (you can swap this with your own degree if it is different). Implement your tables as data frames. Write code to simulate random test data and use it to populate your database. Ensure you enforce referential integrity. Using your simulated data, create at least two charts showing information on module assessment results. Use R Programming language strickly not use c++
c++ program An organization is going to design a small database to store the records of students. They hire you in the development team and assign a small module of the project. You have to store the firstName, LastName, address, sapId, semester, and CGPA of all the students in a class. You are supposed to use 2D character array to store firstName and lastName. To test the working of your module you can fix the class size to 15. Pass these arrays into a displayRecord function which display complete information of all the students in a class. Create a function updateRecord which receives the sapId and search that whether this sapId exist in the array. If it exists than change the firstName, address and CGPA of that student otherwise display a simple message that "record does not exist
Write a C++ program to create a simple shopping cart application. The program should allow users to add items to their cart, specify the quantity of each item, and calculate the total cost of their purchase. The program should have the following features: 1. Item Database: Create an array or a data structure to store information about at least 5 different items available for purchase. • Each item should have a name, price, and a unique identifier. 2. Adding Items to Cart: • Prompt the user to add items to their cart by entering the item's unique identifier and the quantity they want to purchase. • Allow the user to add multiple items to their cart. 3. Calculate Total Cost: • Calculate the total cost of the items in the user's cart, considering the quantity of each item. • Display the total cost to the user. 4. Display Receipt: Display a receipt showing the details of each item in the user's cart, including the item name, quantity, price per unit, and the total cost for each item. 5.…
My homework was to design and implement a simple social network program in Java. I should use an adjacency matrix data structure in my implementation. Write a social network program in Java. The default information for this network is stored in two files: index.txt and friend.txt. The file index.txt stores the names of the people in the network – you may assume that we only store the given names and these names are unique; and friend.txt stores who knows whom. The program must read these two files. The following section describes the format of these two files. The friend.txt takes the following format. The first line is the number of pairs of friends. Each subsequent line has two integer numbers. The first two numbers are the indices of the names. The following is an example of friend.txt:50 31 30 12 41 5 The index.txt stores the names of the people in the network. The first line is the number of people in the file; for example:60 Gromit1 Gwendolyn2 Le-Spiderman3 Wallace4 Batman5…
Every data structure that we use in computer science has its weaknesses and strengthsHaving a full understanding of each will help make us better programmers!For this experiment, let's work with STL vectors and STL dequesFull requirements descriptions are found in the source code file Part 1Work with inserting elements at the front of a vector and a deque (30%) Part 2Work with inserting elements at the back of a vector and a deque (30%) Part 3Work with inserting elements in the middle, and removing elements from, a vector and a deque (40%) Please make sure to put your code specifically where it is asked for, and no where elseDo not modify any of the code you already see in the template file This C++ source code file is required to complete this problem
You will implement the student database management system using the C-structure !!!! 1. Design and implement the student type structure that has first name, last name, id, email address as the fields in the student structure type. Define and implement an add_record function that accepts the array of student structure type as an argument and receives input inside the function using the scanf operator. Define and implement a search_record function that accepts the array of student structure, id as an argument and can search the array of student structure by the id and prints the record if found. Define and…
Write a C++ Program. Create a structure course with some attributes i.e course_ID, course_title, credit_hrs etc.. Then Implement following 5 functions (Known as CRUDS operations which means CREATE, READ, UPDATE, DELETE, SEARCH operations): 1. addAStudent 2. updateAStudent 3. deleteAStudent 4. searchAndDisplayAStudent 5. displayAllstudents After that, create an array of 5 courses in main function. Create a menu in main function to enable user to select and perform the operations we created above. Program must not exit until and unless user wants to do so. Sample Menu: Main Menu --------------- Press 1 to add a Course Press 2 to update a Course Press 3 to delete a Course Press 4 to search and display a Course Press 5 to display all Courses Press e to exit the program
Describe an application that you would expect to involve a static data structure. Then describe an application that you would expect to involve a dynamic data structure.
Please solve in Python 3: As a software engineer, you are hired to arrange cricket players based on their country and type. You have given all the player’s information in a tuple called my_tuple. The players are from 3 countries which are Bangladesh, Australia and England. There are 2 types of players which are “Batters” and “Bowlers”You are given the following nested tuple where each element in the my_tuple is a tuple consisting of a name and a 4 digit ID.my_tuple = (("Mominul", 1101),("Mustafiz", 1202),("Bell", 2101),("Cook", 2103),("Smith", 3101),("Finch", 3102),("Starc", 3203), ("Imrul", 1103), ("Taijul", 1204))Write a python program that will convert this tuple into the following dictionary using the process described below: Your code should work for all types of similar tuple if the sample input is changed.Output dictionary (You just have to print the resultant dictionary. No need to follow the pattern below){'Bangladesh': { 'Batters': ('Mominul', 'Imrul'), 'Bowlers':…
develop a library management system application. Morespecifically, your application should use an array of structuresto keep the details of the booksand the user should be able to add a new book, search for a book and find available books toborrow. The book details entered by the user should be stored in a structure using thefollowing details:• Book ISBN• Book title• Author full name• Publication Year• Availability for loan [yes/no] The user of this application should have the following options in the form of a nice presentedmenu.Add a book: The user should add all the details of each book by answering a set of questions(book isbn? Book title? author? year?). The availability for loan is randomly generated by theprogram (y: yes, n:no). Assume that the maximum number of books that the user can giveyou is 50.Search for a book: The user should be given three options here.▪ Search by the title: The user will input a keyword and the program willsearch for all the titles that contain this…
Implement this C program by defining a structure for each payment. The structure should have at least three members for the interest, principle and balance separately. And store all the payments in a structure array (the max size of which could be 100). Name this C program as loanCalcStruct.c .
In C program Create Student Library with the following components: student_t : user-defined type (StudentID, FirstName, LastName, GPA). scan_student() : function to read (StudentID, FirstName, LastName, GPA). print_student(): function to print a student’s information as follows: Name: John SmithStudent ID: 123456 GPA: 3.5 Create student.h, student.c and main-student.c In main-student.c prompt the user to enter the information needed to create 2 student records then display them in the order they were entered.