Query Mapping between MS-SQL and SQLite

If for some reason you need to migrate your MS-SQL Server database to SQLite Database, among many other things, here are some things that you should pay attention to. Things to consider: Each Statement must end with “;“ Remove references to schema on query eg: References to [dbo]. Select * from [dbo].[table1] in SQL = […]

Read More

Python Replace Texts For Each File

A useful function to replace certain texts for each files in a given folder: Python Replace texts in all Files From a Folder and re-write import os # Getting the current work directory (cwd) thisdir = os.getcwd() folder = thisdir + ‘\\path_to_your_folder’ # r=root, d=directories, f = files for r, d, f in os.walk(folder): for […]

Read More

Create Table In SQL Based On .NET Datatable

Here’s a quick code to generate a “Create Table” query based on your Datatable object. The code is written on C# and it generates a create query for SQL table. I had found this code somewhere on the StackOverflow site and it has proven to be extremely helpful.

Read More

How To Handle Right Click Action On Any Element On The Browser

Bind an event handler to the “contextmenu” Javascript event using jQuery.

This captures any Right Click event happening through out the web page. Now if you want to handle Right Click on a particular element, you can do so by doing something like this:

 

Read More

Update On My Writing Career

Folks at w3Stuffs, which is a web/tech related online content magazine, have asked me to join their team of Authors and create content for them. So, I have been busy authoring articles (tutorials mainly) at w3Stuffs lately. While I have not been able to write anything in my own personal blog here ):, as of […]

Read More

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

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