Data Science with R Data Manipulation-converted (1)

Category: Education

Presentation Description


Presentation Transcript

slide 1:

Data Science with R Data Manipulation Data manipulation Data manipulation is the way toward changing information to make it simpler to peruse or be progressively sorted out. For instance a log of information could be sorted out in sequential order request making singular sections simpler to find. Information control is frequently utilized on web server logs to enable a site proprietor to see their most famous pages just as their traffic sources. The data manipulation main element of Data Science with R Oracle provide Data Manipulation Language commands to exercise data operations in the database. Data operations can be populating the database tables with the application or business data modifying the data and removing the data from the database whenever required. INSET Commend The INSERT order is utilized to store information in tables. The INSERT direction is regularly utilized in higher-level programming dialects for example Visual Basic.NET or C++ as an installed SQL order notwithstanding this order can likewise be executed at the SQLPLUS brief in direction mode. There are two distinct types of INSERT direction. The principal structure is utilized if another line will have a worth embedded in every section of the line. The second type of INSERT order is utilized to embed lines where a portion of the section information is obscure or defaulted from another business rationale. This type of INSERT direction necessitates that you determine segment names for which information are being put away. Syntax INSERT INTO table VALUES column1 value column2 value ... The above language structure can be pursued if the qualities for every one of the sections in the table are clear and known. Data Manipulation Language A data manipulation language DML is a family of computer languages including commands permitting users to manipulate data in a database. This manipulation involves

slide 2:

inserting data into database tables retrieving existing data deleting data from existing tables and modifying existing data. DML is mostly incorporated in SQL databases. DML DML looks like Basic English language and improves effective client collaboration with the framework. The utilitarian ability of DML is composed in control directions like SELECT UPDATE INSERT INTO and DELETE FROM as portrayed beneath: • SELECT: This direction is utilized to recover columns from a table. The language structure is SELECT column names from table name where conditions. SELECT is the most broadly utilized DML direction in SQL. • UPDATE: This direction adjusts information of at least one records. An update order sentence structure is UPDATE table name SET column name value where condition. • INSERT: This direction adds at least one records to a database table. The addition direction language structure is INSERT INTO table name columns VALUES values. • DELETE: This direction expels at least one records from a table as per indicated conditions. Erase direction language structure is DELETE FROM table name where condition. Short for Data Manipulation Language a set of statements used to store retrieve modify and erase data from a database. There are two types of DML: procedural in which the user specifies

slide 3:

what data is needed and how to get it and nonprocedural in which the user specifies only what data is needed. Syntax: SELECT column names from table name Syntax: UPDATE table name SET column name value where condition Syntax: INSERT INTO table name columns VALUES values Syntax: DELETE FROM table name where condition

slide 4:

Data Manipulation Language is of two types: a Procedural – The type of data needed and the mechanism to get it is specified by the user. b Non Procedural – Only the type of data needed is specified by the user. Main difference between Procedural and Non procedural language procedural: the user specifies what data is needed and how to get it Example: Example of Data Manipulation Language Using Java: 1. try 2. Statement st connection.createStatement 3. ResultSet rs st.executeQuery"SELECT FROM students" 4. 5. String s rs.getString1 6. //dst... 7. 8. catchSQLException e Resultset declare what data is needed which are included in the line of the SQL query SELECT FROM students. While the while line states the way to retrieve the data. Nonprocedural: the user only specifies what data is needed. Example: 1. INSERT INTO Employee Id LastName FirstName 2. VALUES 7 Muhammad Faizan 3. For more details you can check Logical operators Multiple arguments to filter are combined with “and”: every expression must be true in order for a row to be included in the output. For other types of combinations you’ll need to use Boolean operators yourself: is “and” | is “or” and is “not”. Figure 1 shows the complete set of Boolean operations.

slide 5:

Figure 1: Complete set of boolean operations. x is the left-hand circle y is the right-hand circle and the shaded region show which parts each operator selects. The following code finds all flights that departed in November or December

slide 6:

Conclusion Data Scientist has been named the number one job in U.S. The U.S. Bureau of Labor Statistics reports that the rise of data science needs will create 11.5M job openings by 2026 R is a leading tool for machine learning statistics and data analysis. It is a programming language. By using R we can create objects functions and packages. R language is a platform independent so we can use it on any operating systems. Biggest scope of data science in future .

authorStream Live Help