Use pandas library on python to solve the following problems : 1. Load titanic.csv dataset. (how can I upload it ??) 2. Print the first 10 rows of the titanic dataset. 3. Print the total number of titanic passengers. 4. Print the number of passengers who survived. 5. Print the name of passengers that survived and age 50 and above. 6. Is there any null values in the dataset? If yes, which attribute?

So I'm having issues with MySQL and my issue is with the orders table where the columns are retrieved but the rows aren't and it's only the orders table and I include the order_line table and it works correctly.

When writing queries in a programming language, why should we avoid creating a query by concatenating strings and instead use prepared statements or stored procedures in defense against SQL injection? a. concatenating strings helps prevent sql injection b. prepared statements or stored procedures help prevent the user/hacker from deliberately modifying the query by injecting sql instructions in the input values c. prepared statements prevent the query from taking as long to execute d. prepared statements enable the developer to just supply values without injecting sql

Suppose that we have an item table and a shipment table. The Item table contains all of the items and the Shipment table contains items received by the company. Shipments Table itemNo description Items Table itemNo 342 345 346 347 description MacBook Pro Lenovo PC 4GB Memory 500GB HD qtyOnHand 10 55 100 6 342 345 347 352 What is the result of executing the following query on this data? MacBook Pro Lenovo PC 500GB HD ITB External Drive qty Received SELECT I.itemNo "Item No", qtyOnHand "Quantity On Hand", S.itemNo "Item Number", qtyReceived "Quantity Received" FROM Items I RIGHT JOIN Shipments S ON (1.itemNo= S.itemNo); O c. 'NULL' appears in the column Item Number. O d. '352' appears in the column Item No. 1 5 6 4 Identify in the list below, a value and the name of a column in which it appears. O a. '346' appears in the column Item No. O b. 'NULL' appears in the column Item No.

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

Use import sys. Use the fastfood.csv file to complete the following assignment. Create a file, fastfood.py, that loads the .csv file and runs a regression predicting calories from total_fat, sat_fat, cholesterol, and sodium, in that order. Add a constant using sm.add_constant(data). Note: you will not need to upload the .csv to CodeGrade because I have pre-loaded it, but you will need to read in the data. Then, print the following to two decimals print(model.mse_total.round(2)) print(model.rsquared.round(2)) print(model.params.round(2)) print(model.pvalues.round(2))

Please solve Question 7 using the SQL command 'NOT EXISTS'. Other relative info includes the data tables below: TABLE `Streams` ( `customer` int NOT NULL, `moviePrefix` char(4) NOT NULL, `movieSuffix` char(4) NOT NULL, `timestamp` timestamp NOT NULL, `duration` int NOT NULL TABLE `Previews` ( `customer` int NOT NULL, `moviePrefix` char(4) NOT NULL, `movieSuffix` char(4) NOT NULL, `timestamp` timestamp NOT NULL TABLE `Movie` ( `prefix` char(4) NOT NULL, `suffix` char(4) NOT NULL, `name` varchar(255) NOT NULL, `description` text NOT NULL, `rating` enum('G','PG','M','MA15+','R18+') NOT NULL, `releaseDate` date DEFAULT NULL TABLE `Customer` ( `id` int NOT NULL, `name` varchar(255) NOT NULL, `dob` date NOT NULL, `bestFriend` int DEFAULT NULL, `subscriptionLevel` varchar(25) NOT NULL

In a well organized essay, not a series of bullets, explain what "hashing" is. What is it used for? What makes it particularly attractive. In your essay be sure to indicate the order of magnitude required to store or to search for data using hashing.

1.6 Using SQL Server (Not Oracle)

Write a python script that will bring two tables "Table 1" and "Table 2" all info from SQL Server and then save it as an excel file with two tabs. Table 1 = tab 1 table 2 = tab 2 Hints: from SQL, you will do query 1 = "select * from table 1" and query 2= "select * from table 2". And all the info save in one excel with two tabs. Please write a python script to do the above task.

Q2) part 1 -Several types of correlation coefficients exist. Go to the help of the cor() function and find which correlation coefficient is calculated by default.-Add the appropriate argument to the cor() function in the previous command so that the Spearman correlation is calculated instead. part 2 -What is the maximum value of weight in the entire dataset?-How many missing values are there for age?-What is the mean value for BMIpre for the two surgical techniques (variable surgery)?-What is the Pearson correlation between the BMI before the operation (BMIpre) and the BMI after the operation (BMIpost)?

CREATE DATABASE COUNTRIES; USE COUNTRIES; DROP TABLE IF EXISTS `City`; CREATE TABLE `City` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `Name` char(35) NOT NULL DEFAULT '', `CountryCode` char(3) NOT NULL DEFAULT '', `District` char(20) NOT NULL DEFAULT '', `Population` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM AUTO_INCREMENT=4080 DEFAULT CHARSET=latin1; -- -- Dumping data for table `City` -- -- ORDER BY: `ID` INSERT INTO `City` VALUES (1,'Kabul','AFG','Kabol',1780000); INSERT INTO `City` VALUES (2,'Qandahar','AFG','Qandahar',237500); INSERT INTO `City` VALUES (3,'Herat','AFG','Herat',186800); INSERT INTO `City` VALUES (4,'Mazar-e-Sharif','AFG','Balkh',127800); INSERT INTO `City` VALUES (5,'Amsterdam','NLD','Noord-Holland',731200); INSERT INTO `City` VALUES (6,'Rotterdam','NLD','Zuid-Holland',593321); INSERT INTO `City` VALUES (7,'Haag','NLD','Zuid-Holland',440900); INSERT INTO `City` VALUES (3068,'Berlin','DEU','Berliini',3386667); INSERT INTO `City` VALUES...

What causes a bucket overflow in a hash file structure, and how does it happen? Was there anything that could be done to reduce the number of overflowing buckets?