Hello world

SQL Operations with Python using SQLite   SQLite is a software library that implements a self-contained, server less, zero-configuration, transactional SQL database engine. SQLite is the most widely deployed SQL database engine in the world. Install SQLite on Windows Step 1 − Go to https://www.sqlite.org/download.html , and download precompiled binaries from Windows section. Step 2 − Download sqlite-shell-win32-*.zip and sqlite-dll-win32-*.zip zipped files. Step 3 − Create a folder C:\>sqlite and unzip above two zipped files in this folder, which will give you sqlite3.def, sqlite3.dll and sqlite3.exe files. Step 4 − Add C:\>sqlite in your PATH environment variable and finally go to the command prompt and issue sqlite3 command, which should display the following result. Creating Database ·          Import the sqlite3 library. ·          Create a connection to the database by ...

This assignment makes use of the following dataset. Titanic Download link:  Titanic.csv Description: Data on passengers of the RMS Titanic. Entries include the name, age, class, fare, gender, and whether or not the passenger survived Notes: A blank entry for age means that the age is unknown Hint: If you're having trouble with VLOOKUP or any of the other functions you want to use, take a look at the  documentation  for Google Sheets. ------------------------------------------------------------------------------------------------------------ Problem 1.  Are there any characteristics shared by all passengers whose fare is 0? Problem 2.  How many married women over age 50 embarked in Cherbourg? (Married women are denoted by "Mrs.") Problem 3.  Which embarkation city had the highest-paying passengers on average? Problem 4.  What is the most common last name among passengers? What is the average number of passengers per last ...

PRACTICAL 2: Hand on with Python Python is an interpreted high-level programming language for general-purpose programming. Created by Guido van Rossum and first released in 1991, Python has a design philosophy that emphasizes code readability, and a syntax that allows programmers to express concepts in fewer lines of code. Python interpreters are available for many operating systems. Python, the reference implementation of Python, is open source software and has a community-based development model, as do nearly all of its variant implementations. Python is managed by the non-profit Python Software Foundation. INSTALLING AND DOWNLOADING (Python: Version 3.6.2) The Python download requires about 30 Mb of disk space; keep it on your machine, in case you need to re-install Python. When installed, Python requires about an additional 90 Mb of disk space. 1.        Logon to https://www.python.org/ The following page will appear in your browser....

DEIT-14610 Big Data Analytics Laboratory  List of Practicals CRUD sql Operations         Hands on with Python sqlite3 and Python Working on Hadoop Ecosystem Installing the hadoop on windows NoSQL Databases Working with Document Database MongoDB ( installation Procedure) CRUD Operation in MongoDB Using Command Line Interface (CLI) SparkML & R programming Basic construct of R programming Data Analysis in R Data visualization libraries in R Machine Learning in SparkML List of Assignments and Tutorials sheet Tutorial  2- Spreadsheet   PROBLEM STATEMENT     SOLUTION   DOWNLOAD SOLUTION  PDF Tutorial 3 Tutorial 4

PRACTICAL 1: CRUD SQL OPERATION CRUD is an acronym for the four basic types of SQL commands: Create , Read , Update , Delete. CRUD is also sometimes used to describe user interface conventions that facilitate viewing, searching, and changing information; often using computer-based forms and reports. 1.       CREATE TABLE: The SQL Create Table statement is used to create new SQL database. SYNTAX: Basic syntax of creating table is as follows. CREATE TABLE table_name (     column1 datatype,     column2 datatype,     column3 datatype,    .... ); The column parameters specify the names of the columns of the table. The datatype parameter specifies the type of data the column can hold (e.g. varchar, integer, date, etc.). SQL CREATE TABLE Example: Figure 1 -creating table The PersonID column is of type int and will hold an...