#Data

Tags: 11 posts

December 1, 2019 • 1 min read

Hackerrank SQL - Aggregation

Following problems are discussed here. To solve the same, please visit hackerrank website{:target="_blank"}. Weather Observation Station 17 Weather Observation Station 18 Weather Observation Station 19 Weather Observation Station 20 …
Read More
tsql
December 1, 2019 • 2 min read

Hackerrank SQL - Advanced Select

Following problems are discussed here. To solve the same, please visit hackerrank website{:target="_blank"}. New Companies Binary Tree Nodes Occupations The PADS Type of Triangle New Companies select company.company_code, company.founder, …
Read More
tsql
March 25, 2019 • 5 min read

Join, Merge, Append and Concatenate

Working with multiple data frames often involves joining two or more tables to in bring out more no. of columns from another table by joining on some sort of relationship which exists within a table or appending two tables which is adding one or …
Read More
python
January 5, 2019 • 2 min read

Subsetting a dataframe in pandas

Importing packages and datasets import pandas as pd # Fetching data from url as csv by mentioning values of various paramters data = pd.read_csv("https://archive.ics.uci.edu/ml/machine-learning-databases/iris/iris.data", header = None, …
Read More
python
January 1, 2019 • 2 min read

T-SQL - Working with subqueries and APPLY

Note : The following scripts are the part of the course on edx titled as: Querying Data with Transact-SQL - Querying Data with Transact-SQL These queries works on AdventureWorks database and information regarding the same can be accessed by visiting …
Read More
tsql
January 1, 2019 • 6 min read

T-SQL - Using Functions and aggregating data

``Note : The following scripts are the part of the course on edx titled as: Querying Data with Transact-SQL - `` [Querying Data with Transact-SQL](https://www.edx.org/course/querying-data-with-transact-sql-0) `` These queries works on AdventureWorks …
Read More
tsql
January 1, 2019 • 3 min read

T-SQL - Querying multiple tables with Joins

Note : The following scripts are the part of the course on edx titled as: Querying Data with Transact-SQL - Querying Data with Transact-SQL These queries works on AdventureWorks database and information regarding the same can be accessed by visiting …
Read More
tsql
January 1, 2019 • 1 min read

T-SQL - Querying multiple tables using Set Operators

Note : The following scripts are the part of the course on edx titled as: Querying Data with Transact-SQL - Querying Data with Transact-SQL These queries works on AdventureWorks database and information regarding the same can be accessed by visiting …
Read More
tsql
January 1, 2019 • 5 min read

T-SQL - Introduction (Part 2)

Note : The following scripts are the part of the course on edx titled as: Querying Data with Transact-SQL - Querying Data with Transact-SQL These queries works on AdventureWorks database and information regarding the same can be accessed by visiting …
Read More
tsql
January 1, 2019 • 6 min read

T-SQL - Introduction (Part 1)

Note : The following scripts are the part of the course on edx titled as: Querying Data with Transact-SQL - Querying Data with Transact-SQL These queries works on AdventureWorks database and information regarding the same can be accessed by visiting …
Read More
tsql
Back to All Tags