Blog

January 1, 2019 • 5 min read

Indexing and Sorting a dataframe using iloc and loc

There are multiple ways in pandas by which a dataframe can be indexed i.e, selecting particular set of rows and columns from a dataframe. For a detailed description over this topic, once can refer official pandas documentation - Indexing and …

python

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 …

tsql

January 1, 2019 • 5 min read

T-SQL - Introduction (Part 2)

tsql

January 1, 2019 • 1 min read

T-SQL - Querying multiple tables using Set Operators

tsql

January 1, 2019 • 3 min read

T-SQL - Querying multiple tables with Joins

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 …

tsql

January 1, 2019 • 2 min read

T-SQL - Working with subqueries and APPLY

tsql

December 23, 2018 • 1 min read

Read data into pandas

Provide column names while reading a dataset in pandas # Import the required modules import pandas as pd Reading the dataset using read.csv() function with mentioning column names in names parameters. #Fetching data from url as csv by mentioning …

python

December 22, 2018 • 1 min read

Connect to azure storage (blob) using python

The following code snippets are on creating a connection to Azure Blob Storage using Python with account access key. For more details on Azure Blob Storage and generating the access key, visit : …

azure

December 20, 2018 • 2 min read

Connect to azure datalake store using python

The following code snippets are on creating a connection to Azure Data Lake Storage Gen1 using Python with Service-to-Service authentication with client secret and client id. Follow the link, for more details on different ways to connect to Azure …

azure