(a) Create a small data frame representing a database of films. It should contain the fields title, director, year, country, and at least three films. (b) Create a second data frame of the same format as above, but containing just one new film. (c) Merge the two data frames using rbind(). (d) Try sorting the titles using sort(): what happens?

(a) Create a small data frame representing a database of films. It should contain the fields title, director, year, country, and at least three films. (b) Create a second data frame of the same format as above, but containing just one new film. (c) Merge the two data frames using rbind(). (d) Try sorting the titles using sort(): what happens?

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter2: Formatting Workbook Text And Data

Section: Chapter Questions

Problem 1.13CP

See similar textbooks

Similar questions

Construct the data using the sample() function: # change n <- your id/100n <- 12345/100a <- sample(n, 30, replace = T)b <- sample(n, 30, replace = T)c <- sample(n, 30, replace = T)d <- sample(n, 30, replace = T)mydata <- data.frame(a,b,c,d)head(mydata) Create a loop over the columns and create a histogram of the data in each column.• First, set up a 2 by 2 plotting space with par(mforw())• Next, write a loop to create four histograms for a,b,c, and d.
Construct the data using the sample() function: # change n <- your id/100n <- 12345/100a <- sample(n, 30, replace = T)b <- sample(n, 30, replace = T)c <- sample(n, 30, replace = T)d <- sample(n, 30, replace = T)mydata <- data.frame(a,b,c,d)head(mydata) Create a loop over the columns and create a histogram of the data in each column.• First, set up a 2 by 2 plotting space with par(mforw())• Next, write a loop to create four histograms for a,b,c, and d. Write in R. Please and thank you.
Computer Science USE R ONLY! create a function that converts any corpus into a data frame with text column and one columne for each meta tag.
How do I read in a specific row in a CSV file in Python without using pandas, list, or enumerate functions? For example, how do I ask to read row 10 in the file, and then ask for row 50, row 20 or row X?
If a and b are two non-empty numerical row vectors (of different lengths) present in Matlab Workspace, what command would you use to create a new vector, called c, that is a combination of a and b (b elements are appended at the end of a)? c = a + b c = transpose(a,b) c = [a; b] c = [a, b]
Computer Science csv file "/dsa/data/all_datasets/texas.csv" Task 6: Write a function "county_locator" that allows a user to enter in a name of a spatial data frame and a county name and have a map generated that shows the location of that county with respect to other counties (by using different colors and/or symbols). Hint: function(); $county ==; plot(); add=TRUE.
Write a program that reads movie data from a csv (comma separated values) file and output the data in a formatted table. The program first reads the name of the CSV file from the user. The program then reads the csv file and outputs the contents according to the following requirements: Each row contains the title, rating, and all showtimes of a unique movie. A space is placed before and after each vertical separator (|) in each row. Column 1 displays the movie titles and is left justified with a minimum of 44 characters. If the movie title has more than 44 characters, output the first 44 characters only. Column 2 displays the movie ratings and is right justified with a minimum of 5 characters. Column 3 displays all the showtimes of the same movie, separated by a space. Each row of the csv file contains the showtime, title, and rating of a movie. Assume data of the same movie are grouped in consecutive rows. Ex: If the input of the program is: movies.csv and the contents of movies.csv…
Write a program that reads movie data from a CSV (comma separated values) file and output the data in a formatted table. The program first reads the name of the CSV file from the user. The program then reads the CSV file and outputs the contents according to the following requirements: Each row contains the title, rating, and all showtimes of a unique movie. A space is placed before and after each vertical separator ('|') in each row. Column 1 displays the movie titles and is left justified with a minimum of 44 characters. If the movie title has more than 44 characters, output the first 44 characters only. Column 2 displays the movie ratings and is right justified with a minimum of 5 characters. Column 3 displays all the showtimes of the same movie, separated by a space. Each row of the CSV file contains the showtime, title, and rating of a movie. Assume data of the same movie are grouped in consecutive rows. Hints: Use the find() function to find the index of a comma in each row of…
Write a program that reads movie data from a csv (comma separated values) file and output the data in a formatted table. The program first reads the name of the CSV file from the user. The program then reads the csv file and outputs the contents according to the following requirements: Each row contains the title, rating, and all showtimes of a unique movie. A space is placed before and after each vertical separator (|) in each row. Column 1 displays the movie titles and is left justified with a minimum of 44 characters. If the movie title has more than 44 characters, output the first 44 characters only. Column 2 displays the movie ratings and is right justified with a minimum of 5 characters. Column 3 displays all the showtimes of the same movie, separated by a space. Each row of the csv file contains the showtime, title, and rating of a movie. Assume data of the same movie are grouped in consecutive rows. Ex: If the input of the program is: movies.csv and the contents of movies.csv…
Using Rstudio, Create a list that contains a numeric vector from (1 to 30, 34, 45, 47, and 50 to 70), a character vector that repeat the elements A, B, and C 30 times, and a 2 x 3 matrix that contains a number from 101 to 106 filled by rows.
1)Consider the following DTD. All unspecified elements are #PCDATA.<!DOCTYPE bibliography [<!ELEMENT book (title,author+,year,publisher,place?)><!ELEMENT article (title,author+,journal,year,number,volume,pages?)><!ELEMENT author (last_name, first_name)>...]>Write the following queries in XQuery. Assume Last names of authors are unique.(a) List all books authored by Ullman.(b) List articles published in Vol. 32 No. 2 of ACM Transactions on Database Systems.(c) List journals that published an article on XML in 2001 (that is, “XML” appears in the title of thearticle).(d) List authors that have published a book in 2001 and another book in 2003.(e) List publishers, and for each publisher list the books they have published as subelements. Chooseappropriate tags for your output.(f) List every author, and for each author list the number of articles he/she published in 2001. Chooseappropriate tags for your output.
1)Consider the following DTD. All unspecified elements are #PCDATA.<!DOCTYPE bibliography [<!ELEMENT book (title,author+,year,publisher,place?)><!ELEMENT article (title,author+,journal,year,number,volume,pages?)><!ELEMENT author (last_name, first_name)>...]>Write the following queries in XQuery. Assume Last names of authors are unique.(a) List all books authored by Ullman.(b) List articles published in Vol. 32 No. 2 of ACM Transactions on Database Systems.(c) List journals that published an article on XML in 2001 (that is, “XML” appears in the title of thearticle).(d) List authors that have published a book in 2001 and another book in 2003.(e) List publishers, and for each publisher list the books they have published as subelements. Chooseappropriate tags for your output.(f) List every author, and for each author list the number of articles he/she published in 2001. Chooseappropriate tags for your output. answer d,e,f questions