How to read multiple CSV/Excel files in R and write in SQL?
Suppose, you have multiple CSV/Excel files, assume 100,200 in a folder or may be in a different folder. You want to write all those files to MS SQL through R. If you will do...
Category: Data analytics
How Data science is affecting all our life for better use!
All over the world, we are seeing a massive increase in the amount of data we record and analyze for the greater good of humanity. Here I would throw some light on how data...
Visualizing geospatial data using Folium
In this blog, I will discuss a very interesting data visualization library in python which is Folium. I will show you how to use it along with examples. Folium is a powerful data visualization...
Skills Every Data Scientist Aspirant Should Learn
Data Scientist is termed as ‘Sexist Job of the 21st century’. As this field has become so popular now-a-days, I thought I should write on what should be the most important skills/responsibilities that every...
Data Analysis ToolPak in Excel(add-in)
The Data Analysis ToolPak is an Excel add-in which usually used to perform statistical analytics like Regression, Covariance , Correlation, etc. Just follow the below simple steps to load Data Analysis ToolPak add-in in...
How to create a new blank dataframe in Pandas ?
Pandas is a software library written for the Python programming language for data manipulation and analysis. Dataframe is a 2-d labelled data structure consists of columns of different types. You can think of it...
Basic Overview of Data Analytics
In this blog, I will give you a basic overview of Data Analytics and try to answer some of the questions like – What is data analytics, How Data analytics is important and helping...
Importance of data visualization
In this blog, we will discuss about how important data visualization is. It gives the appropriate insight which helps to take business decision. Let discuss why and how it is important. What is Data...
Infographic representation of crimes in India
In this blog I will show the visualizations of the crimes related to dacoity, theft, robbery and burglary happened in India between 2001-2012. I have done this observation with the help of jupyter notebook,...