Author: datapandasadmin

Connect Push Commit Pull Your GitHub Repository To Your Local Computer’s Directory
| |

Connect Push Commit Pull Your GitHub Repository To Your Local Computer’s Directory

Introduction Github is a web version control system which is very useful when you are working on various projects or you want to keep track of changes you make to your project over time. It is a very useful tool as you venture into Data Science and Programming   Objective After you have created a…

Data Analytics Framework – Simple Short Notes For Aspiring Data Analysts
|

Data Analytics Framework – Simple Short Notes For Aspiring Data Analysts

In the process of Data Analysis, sometimes, we are too engrossed and happy about the available data and try to jump straight into the data and make a lot of analysis and then later try to fit our analysis round business problems whether or not they exist. Hence we try to even make up problems…

Google Data Studio is Free For Everyone: Take Your Analytics To The Next Level
|

Google Data Studio is Free For Everyone: Take Your Analytics To The Next Level

On February 2, 2017, Nick Mihailovski, Product Manager, Google Data Studio announced that Google Data Studio is now free for everyone. That the limit on 5 Reports has been removed and you can now create as many reports as you want.   He stated: “To enable more businesses to get full value from Data Studio we are making…

| |

How To Use ER Assistant – FREE Entity Relationship Diagram (ERD) Creation Tool

There are a lot of ER Diagram Tools. However, by far, one of the favourite ones I use is the ER Assistant which is also free. You can download the ER Assistant free software from here: ER Assistant Download. Install the program after download. In this post, we will learn how to Create Entities Create…

Drop Shipping Ecommerce Database ER Diagram and Conceptual Modeling
|

Drop Shipping Ecommerce Database ER Diagram and Conceptual Modeling

In this short article, we look at a sample ERD Diagram which is designed using ER-Assistant software (usage of this software is covered here: How To Use ER Assistant) after we have finished with the Conceptual Modeling. Hence in the first place, we have to gather some Data requirements. This involves business logic and requirements,…

Generating Dummy Data In Talend For Testing and Development And Inserting Into PostgreSQL

Generating Dummy Data In Talend For Testing and Development And Inserting Into PostgreSQL

Handling customer data is very key and sometimes, you do not want to use your real customer’s data and information during development. However you would want to generate some dummy data in Talend and use for your development and testing purposes. In this short tutorial, we are going to use TRowGenerator in Talend and then…

Run Explore Frequency Distribution of Your Dataset in SAS Studio
|

Run Explore Frequency Distribution of Your Dataset in SAS Studio

SAS Studio is a very powerful statistical program which are used by many corporations for various analytic and data science tasks. We briefly want to look at how we can check sum frequency statistics on some columns / attributes in our data. lets set the library name for our working directory where our dataset is…

WindowsError: [Error 5] Access is denied: Anaconda Python Pip Installs and Upgrade

I was trying to run a pip install ( pip install scikit-learn) and I encountered this error: C:\Users\adaba>pip install -U scikit-learn Collecting scikit-learn Using cached scikit_learn-0.18.1-cp27-cp27m-win_amd64.whl Installing collected packages: scikit-learn Found existing installation: scikit-learn 0.17.1 DEPRECATION: Uninstalling a distutils installed project (scikit-learn) has been deprecated and will be removed in a future version. This is…