New Project: Gigyasa

Hello, This post is about introducing my new writing project “Gigyasa“. It is an online Blog Magazine where I will be writing and sharing some wisdom about Life on general that I have collected over the years. I had been writing much notes here and there previously on my notebooks much of which were just […]

Read More

Web Scraping Quotes From Good Reads

Introduction GoodReads is a very good resource for info about books, authors and interesting quotations. In this post, I will share a piece of code that will allow you to scrape for quotations from this site. The code is written for python’s Scrapy framework. Getting Started To get started with scraping quotes from your favorite […]

Read More

How To Create A WordPress Blog From R Markdown?

Creating a WordPress blog directly from R Studio The library packages that you would need for this purpose are: RWordPress knitr library(RWordPress) library(knitr) You can download RWordPress¬† package from Git hub. After you have the libraries loaded, you need to set up access to your wordpress site. For that, you will need: XML-RPC of your […]

Read More

First Exploratory Data Analysis on Kaggle

Here’s link to my first Exploratory Data Analysis Kernel on Kaggle. The data set was for Emergency (911) Calls: Fire, Traffic, EMS for Montgomery County, PA. I have used “ggplot2” and “sqldf” R packages on most parts to perform data analysis and exploration for this project. Check it out!    

Read More

Connecting to SQL Database Servers

This is a second post in the series “Are you ready to work as a SQL Developer?” Your path to Database design, development and maintenance begins from the gateway called SQL Server Management Studio (SSMS), an integrated environment for managing any SQL infrastructure, from SQL Server to SQL Database. Once you have your SQL Server […]

Read More

Color Usage In Data Analysis

Data Visualization is an integral part of Data Science and Data Analysis. It is a way of beautifully presenting information rather than using traditional spreadsheets and reports. Humans, by nature, can more easily process information when provided with beautiful visualization as our brains are designed this way. By the use of right visualization, we can […]

Read More

Upload Image and Create Thumbnail

In this post, I will show an implementation of uploading image to server and creating a thumbnail version of the uploaded image. Creating a thumbnail is useful as it reduces image size and dimensions and improves application’s performance. In your ASP.NET Controller’s HttpPost Action, you can get the uploaded image file as HttpPostedFileBase as: HttpPostedFileBase […]

Read More

Implementing Inbox Messaging System in ASP.NET

In this post, I would like to write about creating a simple Messaging System for your application. Almost all user based applications require some form of messaging system. Mainly the messaging system is needed so that users within the application can send messages to one another and also, it is needed to show any form […]

Read More

Get Random Date From A Date Range

This is a quick trick to generate a random date between two date ranges. First, create a function that generates a random number between two given values: private static int RandomNumBetween(int smallNum, int bigNum) { Random rnd = new Random(); int randomValue = rnd.Next(smallNum, bigNum + 1); return randomValue; } Now, use this function to […]

Read More

C# : Write DataTable To CSV

Here’s a quick code to write data from database to a CSV format file in C# .NET. I find this function really useful as I frequently come across this scenario where I have to create a report for the client. Once our data is loaded into a DataTable, this function can be used. public static […]

Read More