Blog – Page 4 – DataPandas

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

January 6, 2017 2 Comments

Entity Relationship Diagram – ERD and Cardinality Symbols Simple Explanations

Understading cardinality notation and being able to explain them will go a long way in your database design and implementation. Here we look at a simple explanation of the symbols. (Credit to Data Warehousing for Business Intelligence by University of Colorado System on Coursera) Symbols in the above diagram and their meanings: – Oval: means 0 –

December 30, 2016 No Comments

Business Intelligence - BI

Superset Caravel BI Tool Installation and Visualizations on Heroku

Superset (formerly called Caravel ) BI Tool by http://airbnb.io/superset is a free Data Visualization tool which you can harness its powers for your visualization analytic needs. If you are finding problems installing on your windows PC or you simply want your own online version you can simply sign up FREE with Heroku (at least choosing

December 28, 2016 No Comments

Business Intelligence - BI

Populating Superset Caravel MySQL database tables with Data via Heroku

If you installed your Superset (Caravel) BI Tool with Heroku and if you are finding it difficult to initially populate your MySQL database tables with Data and you will be using MySQL the default database that come with your installation, then you can follow these steps to get data into Superset. (By the way, you

December 28, 2016 No Comments

Merry Christmas :) !!!

December 27, 2016 No Comments

Data Warehousing

SQL Statement Query Clause Evaluation Order – Which Part of SQL Statements Execute First and in What Order?

Which Part of SQL Statements Execute First and in What Order. It is very important to understand which parts of the SQL Statement executes first and which part comes next until full completion. The diagram below gives an overview of the execution order. The steps in which the SQL statement is executed are as below:

December 6, 2016 No Comments

Google APIs

Connect Google Big Query to Talend Open Studio and Pull Data From Big Query

This is just a quick guide to connect Google Big Query to Talend Open Studio for Big Data and use query to retrieve Data from Big Query into Talend. This means you will need the Talend Open Studio for Big Data Integration version. (You will have to download and install that if you do not have that

December 4, 2016 No Comments

NullPointerException – Eg 1 When Instance of an Object Is set to Null and It Is Used as A reference

java.lang.NullPointerException exception is one of the most popular errors in Java and it is caused by so many issues. One of such issues is when an objected is initiated to a Null value and then its reference is used to call a method or a variable. Example is in the code below. /* * To

December 4, 2016 No Comments

Data Warehousing

Free Entity Relationship and Relational Schema Diagram Tool

ERDPLUS One tool I generally use when working on a projects, mini tasks and exploration is the ERDPLUS tool . It is quite simple and easy to use. It is a Free tool as well. Below are some diagrams I generated when i first got in contact with with tool. ERD DIAGRAMS: 1. 2. A

November 27, 2016 No Comments

Creating Oracle PL/SQL Tables for Intercollegiate Athletic Database – Data Warehousing

Creating Oracle tables for Intercollegiate Athletic Database. Part of Assignment one of Data Warehousing for Business Intelligence on Coursera –1 CREATE TABLE FACILITY CREATE TABLE FACILITY( FACNO VARCHAR(12), FACNAME VARCHAR(255) NOT NULL, CONSTRAINT PK_FAC PRIMARY KEY (FACNO) ); –2.REATE TABLE EMPLOYEE CREATE TABLE EMPLOYEE( EMPNO VARCHAR(12), EMPNAME VARCHAR(255) NOT NULL, DEPARTMENT VARCHAR(100) NOT NULL, EMAIL VARCHAR(50) NOT