
Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Question
python coding
(Pandas: Series) Perform the following tasks with pandas Series:
a) Create a Series from the list [7,11,13,17].
b) Create a Series with five elements that are all 100.0.
c) Create a Series with 20 elements that are all random numbers in the range 0 to100. Use method describe to produce the Series’ basic descriptive statistics.
d) Create a Series called temperatures of the floating-point values 98.6, 98.9,100.2 and 97.9. Using the index keyword argument, specify the custom indi-ces 'Julie', 'Charlie', 'Sam' and 'Andrea'.
e) Form a dictionary from the names and values in Part (d), then use it to initializea Series.
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution
Trending nowThis is a popular solution!
Step by stepSolved in 3 steps with 3 images

Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- 1-24 Complete the following code. Ignore any highlighted answers, those are all not correct. thank youarrow_forwardradius_mean gives the average size of the cells in terms of the radius of circles drawn around each cell in the biopsy. texture_mean provides the amount of variation in light to dark values in an image of the cells. sb.regplot (data = cancer, x = "radius_mean", y = "texture_mean", "lowess = True, line_kws = {"color": "orange"}) --INSERT-- 40 texture_mean 35 20 15 10 10 15 20 radius_mean 25 Provide a brief explanation of what is displayed in this plot. Be sure to comment on the orange line and how it expresses the conditional mean of "texture_mean" for different values of "radius_mean."arrow_forward# Create Custom Transformer Create a custom transformer, just as we did in the lecture video entitled "Custom Transformers", that performs two computations: 1. Adds an attribute to the end of the numerical data (i.e. new last column) that is equal to $\frac{x_1^3}{x_5}$ for each observation. In other words, for each instance, you will cube the $x_1$ column and then divide by the $x_5$ column. 2. Drops the entire $x_4$ feature column if the passed function argument `drop_x4` is `True` and doesn't drop the column if `drop_x4` is `False`. (See further instructions below.) You must name your custom transformer class `Assignment4Transformer`. Your class should include an input parameter called `drop_x4` with a default value of `True` that deletes the $x_4$ feature column when its value is `True`, but preserves the $x_4$ feature column when you pass a value of `False`. This transformer will be used in a pipeline. In that pipeline, an imputer will be run *before* this transformer. Keep…arrow_forward
- add code to display the information of each part in addition to the total inventory value in a table format. Old part number is OLS0001, quantity 30 and price 0.80, 24 is total inverntory Expected output: SMS0001 0.35 20 7.00 OLS0001 0.80 30 24.00 #include <stdlib.h>#include <stdio.h>#include <string.h>int main() { struct partitem { char number[10]; float price;};struct partitem part, oldpart;int oldpartqty; float oldpartprice;int qty = 20;part.price = 0.35;strcpy(part.number,"SMS0001");printf("price = %.2f\n",part.price);printf("name = %s \n", part.number);printf("quantity %d \n",qty );printf("enter oldpart\n");scanf("\n %s",oldpart.number);printf("\nold part number is %s",oldpart.number);printf("\nold part price");scanf( "%f",&oldpartprice);printf("old part qty");scanf("%d",&oldpartqty);printf("the price of the old part is %.2f \n",oldpartprice);printf("the qty of the old part is %d \n",oldpartqty);return 0;}arrow_forwardpython: numpy def purchases(transactions): """ QUESTION 7 - A high-end store is trying to evaluate the total amount that customer's spend per transaction. They want customers to spend anywhere between $130 and $150 on average. - You need to determine whether the average number spent on each transaction per month is above, between, or below the desired amount. - Transactions is a numpy array containing a date, total amount earned each month, and total number of transactions each month. - Above: month's average amount spent per transaction > 150 - Within Range: 150 >= month's average amount spent per transaction >= 130 - Below: month's average amount spent per transaction < 130 - Return a numpy array with "Above", "Within Range" and "Below" for the average amount spent per transaction per month - THIS MUST BE DONE IN ONE LINE HINT: use np.where() and convert the type of each column to float Args: transactions…arrow_forwardPlease add comments! thanks!arrow_forward
- Counting hashtags Write Python code to count the frequency of hashtags in a twitter feed. Your code assumes a twitter feed variable tweets exists, which is a list of strings containing tweets. Each element of this list is a single tweet, stored as a string. For example, tweets may look like: tweets = ["Happy #IlliniFriday!", "It is a pretty campus, isn't it, #illini?", "Diving into the last weekend of winter break like... #ILLINI #JoinTheFight", "Are you wearing your Orange and Blue today, #Illini Nation?"] Your code should produce a sorted list of tuples stored in hashtag_counts, where each tuple looks like (hashtag, count), hashtag is a string and count is an integer. The list should be sorted by count in descending order, and if there are hashtags with identical counts, these should be sorted alphabetically, in ascending order, by hashtag. From the above example, our unsorted hashtag_counts might look like: [('#illini', 2), ('#jointhefight', 1),…arrow_forward### Import section# 3 necessary statements for numerical plotting in Jupyterimport numpy as npimport matplotlib.pyplot as plt %matplotlib inline# Factorial comes from 'math' packagefrom math import factorial ### Initialization section#array of derivatives at 0 compute by handderiv = np.array([1, 0, -1, 0, 1, 0, -1, 0])# degree of Taylor polynomialN=len(deriv)-1 # Max abs. value of N+1 deriv on interval (Compute using calculus)# (used in the remainder formula)# @@@ The N+1 derivative will be proportional to cosine, and |cos| is always # @@@ less than 1maxAbsNplus1deriv=1 #array with h valuesh = np.arange(-3,3.005,0.01) # Give the expansion point for the Taylor seriesexpansion=0 # Create an array to contain Taylor seriestaylor = np.zeros(len(h)) ### Calculation section#calculate Taylor series for all h at once using a loopfor n in range(N+1): taylor = taylor + (h**n)/factorial(n)*deriv[n] #actual function values actualFn = np.cos(expansion+h) #error actual and taylor…arrow_forwardC++ you have to you use #include <random> also included a sample output has too match the layout Thank youarrow_forward
- Alphabet Random Walk• Write a program to generate a random walk that spans a 10*10 character array (The initial values of the elements are all.). The program must randomly walk from one element to another, moving one element position up, down, left or right each time. The elements that have been visited are labeled with the letters A through Z in the order in which they were visitedarrow_forwardWrite the statement that declares and instantiates an array of type double using the identifier temperatures that will hold 30 values. Edit View Insert Format Tools Table 12pt v Paragraph v :arrow_forwardFor any element in keysList with a value greater than 50, print the corresponding value in itemsList, followed by a comma (no spaces). Ex: If the input is: 32 105 101 35 10 20 30 40 the output is: 20,30, 1 #include 2 3 int main(void) { const int SIZE_LIST = 4; int keysList[SIZE_LIST]; int itemsList[SIZE_LIST]; int i; 4 6 7 8 scanf("%d", &keysList[0]); scanf ("%d", &keysList[1]); scanf("%d", &keysList[2]); scanf("%d", &keysList[3]); 10 11 12 13 scanf ("%d", &itemsList[0]); scanf ("%d", &itemsList[1]); scanf("%d", &itemsList[2]); scanf ("%d", &itemsList[3]); 14 15 16 17 18 19 /* Your code goes here */ 20 21 printf("\n"); 22 23 return 0; 24 }arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education

Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education

Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON

Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON

C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON

Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning

Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education