(1)Let's visit the billboard hot 100 page"https://www.billboard.com/charts/hot-100". Retrieve the followinginformation: i) the rank of the song, ii) the artist's name, iii) the title of thesong. Create a data frame to store this information. Rename your columnsas "hot100.rank", "hot100.artist", "hot100.title". Your dataset should looklike the following. Create a function with one input. The output of the function5is.If the input is a specific artist's name that exists in the data frame thatyou just created, then this function returns all his(her) songs on chart.If the input is a specific word "List", then this function returns all thenames of the artists that are on chart.If the input is an artist's name that is in the data frame, or any otherinput, then return "Invalid Input".

Let's delve into a more detailed explanation of the solution provided.**1. Fetching Data from…

Answered: (1) Let's visit the billboard hot 100…

New Perspectives on HTML5, CSS3, and JavaScript

6th Edition

ISBN:9781305503922

Author:Patrick M. Carey

Publisher:Patrick M. Carey

Chapter6: Working With Tables And Columns: Creating A Program Schedule For A Radio Station

Section: Chapter Questions

Problem 8CP3

See similar textbooks

Similar questions

Create a new table containing the category code and description for the categories of books sold by JustLee Books. The table should be called CATEGORY, and the columns should be CatCode and CatDesc. The CatCode column should store a maximum of 2 characters, and the CatDesc column should store a maximum of 10 characters.
In the Media Posts worksheet, in column G of the Facebook table, apply the VLOOKUP function to categorize the size of each post, using the value Characters field for the lookup value, the Character_Lookup table as the lookup table, and the second column of the table as the return value.
8.Create a Frequency table to identify the Shopping Basket size using the “FREQUENCY” function and “Net Sales” column. Create a Bin Table to create a Frequency Table (bin array – 0-$10, $11-$20, $21-30, $31-40, $41-50).
Create a mailing list from the CUSTOMERS table. The mailing list should display the name, address, city, state, and zip code for each customer. Each customer’s name should be listed in order of last name followed by first name, separated with a comma, and have the column header “Name.” The city and state should be listed as one column of output, with the values separated by a comma and the column header “Location.”
Create a website registration form to obtain a user’s first name, last name and e-mail address. In addition, include an optional survey ques- tion that asks the user’s year in college (e.g., Freshman). Place the optional survey question in a details element that the user can expand to see the question.
Microsoft Excel Formula assignment: The objective of this assignment is to create 20 [5x5] tables and each 5 by 5 table will have mix of numbers from 1 to 100. (NOTE: There can't be ANY duplicate numbers in the 25 cells). The numbers placed in the 5x5 table cannot match with any other table AND again, each table cannot repeat the same number. I need to create this without having to manually type numbers and create the 5 by 5 tables.What is the fastest way to create these tables using formulas? This assignment demonstates the examples for formulas on excel. Here is two examples for 2 tables.TABLE 1:1 2 3 4 56 7 8 9 1011 12 13 14 1516 17 18 19 2021 22 23 24 25TABLE 2:59 2 3 4 133 72 8 9 6611 22 13 88 1516 17 18 19 529 40 99 30 21Here is an example that will NOT work.1 2 66 4 216 7 8 7 910 11 12 39 4182 88 88 88 29100 33 35 32 51
Please continue the codes of the remaining items (4-6).
use the code below to create tabels. include screenshots CREATE TABLE PRICE ( PRICE_CODE NUMBER(2,0) PRIMARY KEY, PRICE_DESCRIPTION VARCHAR2(20) NOT NULL , PRICE_RENTFEE NUMBER(5,2) CHECK (PRICE_RENTFEE >= 0), PRICE_DAILYLATEFEE NUMBER(5,2) CHECK (PRICE_DAILYLATEFEE >= 0) ); CREATE TABLE MOVIE ( MOVIE_NUM NUMBER(8,0) PRIMARY KEY, MOVIE_TITLE VARCHAR2(75) NOT NULL, MOVIE_YEAR NUMBER(4,0) CHECK (MOVIE_YEAR > 1900), MOVIE_COST NUMBER(5,2), MOVIE_GENRE VARCHAR2(50), PRICE_CODE NUMBER(2,0) CONSTRAINT MOVIE_PRICE_CODE_FK REFERENCES PRICE ); CREATE TABLE MEMBERSHIP ( MEM_NUM NUMBER(8,0) PRIMARY KEY, MEM_FNAME VARCHAR2(30) NOT NULL, MEM_LNAME VARCHAR2(30) NOT NULL, MEM_STREET VARCHAR2(120), MEM_CITY VARCHAR2(50), MEM_STATE CHAR(2), MEM_ZIP CHAR(5), MEM_BALANCE NUMBER(10,2) ); PRICE: INSERT INTO PRICE VALUES (1, 'Standard', 2, 1); INSERT INTO PRICE VALUES (2,…
CREATE TABLE consumer ( ConsumerID INT PRIMARY KEY, FirstName VARCHAR(50), LastName VARCHAR(50), Age INT, Gender VARCHAR(10), OnlineInStore VARCHAR(20)); INSERT INTO consumer (ConsumerID, FirstName, LastName, Age, Gender, OnlineInStore) VALUES (1, 'John', 'Doe', 25, 'Male', 'Online');INSERT INTO consumer (ConsumerID, FirstName, LastName, Age, Gender, OnlineInStore) VALUES (2, 'Jane', 'Smith', 30, 'Female', 'In-store');INSERT INTO consumer (ConsumerID, FirstName, LastName, Age, Gender, OnlineInStore) VALUES (3, 'Mike', 'Johnson', 20, 'Male', 'Online');INSERT INTO consumer (ConsumerID, FirstName, LastName, Age, Gender, OnlineInStore) VALUES (4, 'Sarah', 'Williams', 35, 'Female', 'In-store');INSERT INTO consumer (ConsumerID, FirstName, LastName, Age, Gender, OnlineInStore) VALUES (5, 'Chris', 'Davis', 28, 'Male', 'Online'); CREATE TABLE InStoreRetailer ( RetailerID INT PRIMARY KEY, RetailerName VARCHAR(50), StoreLayout VARCHAR(50), CustomerService…
CREATE TABLE Employee( Eid INT PRIMARY KEY, E_name VARCHAR(20), E_Age INT CHECK (E_Age between 18 and 60), ECity VARCHAR(20), E_Street VARCHAR(20), E_House# INT, E_Basic_Salary DECIMAL(18,2), E_Bonus DECIMAL(18,2), E_Rank VARCHAR(20) CHECK (E_Rank IN('Manager','Develper','Admin')), E_Department VARCHAR(20) DEFAULT 'CS' CHECK (E_Department IN ('HR','CS','IT','Labour'))); Create Table Porjects: CREATE TABLE Project1( p_id INT , pName VARCHAR(20), p_bonus DECIMAL(18,2), duration_in_months INT, Eid INT, PRIMARY KEY(p_id,Eid), FOREIGN KEY(Eid) REFERENCES Employee(Eid)); now the question is... Display Total expenditures of company. (total expenditures = basic salary + bonus of employee + all project bonus) Display names of projects in which ‘Ahmar’ is Display total project bonus of ‘Danish’. Display total expenditures of only those departments whose total expenditures are more than 1 Million. (total expenditures = sum of basic salary of all employees of that…
Create a custom form based on the qryBalanceContacts query. Display all fields from the query in the form. Create your own design for the form. Add a label to the bottom of the Detail section that contains your first and last names. Change the label's font so that your name appears in bold, blue font. Change the BalanceDue text box format so that the field value is displayed in bold, red font. Save the form as frmBalanceContacts. Please show step by step how to do this in ACCESS.
Create a formula that provides this information as follows: In cell H3, begin to enter a formula using the VLOOKUP Use the Project ID (cell H2) as the lookup value. Use the Lookup table (range A2:E23) as the table_array. Use the Project Name column (column 2) as the col_index_num. Specify an exact match (FALSE) for the range_lookup.

SEE MORE QUESTIONS

Recommended textbooks for you

New Perspectives on HTML5, CSS3, and JavaScript

Computer Science

ISBN:

9781305503922

Author:

Patrick M. Carey

Publisher:

Cengage Learning

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE

Computer Science

ISBN:

9780357392676

Author:

FREUND, Steven

Publisher:

CENGAGE L

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

New Perspectives on HTML5, CSS3, and JavaScript

Computer Science

ISBN:

9781305503922

Author:

Patrick M. Carey

Publisher:

Cengage Learning

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE

Computer Science

ISBN:

9780357392676

Author:

FREUND, Steven

Publisher:

CENGAGE L

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

Np Ms Office 365/Excel 2016 I Ntermed

Computer Science

ISBN:

9781337508841

Author:

Carey

Publisher:

Cengage

SEE MORE TEXTBOOKS