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 due to the fact that uninstalling a distutils project will only partially uninstall the project.

Uninstalling scikit-learn-0.17.1:

Exception:

Traceback (most recent call last):

File "C:\Program Files\Anaconda2\lib\site-packages\pip\basecommand.py", line 215, in main

status = self.run(options, args)

File "C:\Program Files\Anaconda2\lib\site-packages\pip\commands\install.py", line 317, in run

prefix=options.prefix_path,

File "C:\Program Files\Anaconda2\lib\site-packages\pip\req\req_set.py", line 736, in install

requirement.uninstall(auto_confirm=True)

File "C:\Program Files\Anaconda2\lib\site-packages\pip\req\req_install.py", line 742, in uninstall

paths_to_remove.remove(auto_confirm)

File "C:\Program Files\Anaconda2\lib\site-packages\pip\req\req_uninstall.py", line 115, in remove

renames(path, new_path)

File "C:\Program Files\Anaconda2\lib\site-packages\pip\utils\__init__.py", line 267, in renames

shutil.move(old, new)

File "C:\Program Files\Anaconda2\lib\shutil.py", line 303, in move

os.unlink(src)

WindowsError: [Error 5] Access is denied: 'c:\\program files\\anaconda2\\lib\\site-packages\\scikit_learn-0.17.1-py2.7.egg-info'

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.

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

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

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

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

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

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 .

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

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

--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 NULL,

PHONE VARCHAR(30) NOT NULL,

CONSTRAINT PK_EMP PRIMARY KEY (EMPNO),

CONSTRAINT CHK_EMP CHECK(LENGTHB(PHONE) BETWEEN 5 AND 30)

);

--3 RESOURCETBL

CREATE TABLE RESOURCETBL(

RESNO VARCHAR(12),

RESNAME VARCHAR(255) NOT NULL,

RATE NUMBER(8,2) NOT NULL,

CONSTRAINT PK_RES PRIMARY KEY (RESNO)

);

ALTER TABLE

CUSTOMER

drop constraint

CHK_CUS_ZIP;

ALTER TABLE CUSTOMER

ADD CONSTRAINT CHK_CUS_ZIP CHECK(LENGTHB(ZIP) <=10)

--4 CUSTOMER

CREATE TABLE CUSTOMER(

CUSTNO VARCHAR(12),

CUSTNAME VARCHAR(255) NOT NULL,

ADDRESS VARCHAR(255) NOT NULL,

INTERNAL CHAR(1) NOT NULL,

CONTACT VARCHAR(255) NOT NULL,

PHONE VARCHAR(30) NOT NULL,

CITY VARCHAR(50) NOT NULL,

STATE CHAR(2) NOT NULL,

ZIP INTEGER NOT NULL,

CONSTRAINT PK_CUS PRIMARY KEY (CUSTNO),

CONSTRAINT CHK_CUS CHECK (LENGTHB(PHONE) BETWEEN 5 AND 30),

CONSTRAINT CHK_CUS_ZIP CHECK(LENGTHB(ZIP) <=10)

);

--5 LOCATION

CREATE TABLE LOCATION(

LOCNO VARCHAR(12),

FACNO VARCHAR(12),

LOCNAME VARCHAR(255) NOT NULL,

CONSTRAINT PK_LOC PRIMARY KEY (LOCNO),

CONSTRAINT FK_LOC FOREIGN KEY (FACNO)

REFERENCES FACILITY

);

-- 6 EVENTREQUEST

CREATE TABLE EVENTREQUEST(

EVENTNO VARCHAR(12),

DATEHELD DATE NOT NULL,

DATEREQ DATE NOT NULL,

CUSTNO VARCHAR(12),

FACNO VARCHAR(12),

DATEAUTH DATE NOT NULL,

STATUS VARCHAR(20) NOT NULL,

ESTCOST NUMBER(8,2) NOT NULL,

ESTAUDIENCE INTEGER NOT NULL,

BUDNO VARCHAR(12),

CONSTRAINT PK_EVR PRIMARY KEY (EVENTNO),

CONSTRAINT FK_EVR_CUS FOREIGN KEY (CUSTNO) REFERENCES CUSTOMER,

CONSTRAINT FK_EVR_FAC FOREIGN KEY (FACNO) REFERENCES FACILITY,

CONSTRAINT CHK_AUD CHECK(ESTAUDIENCE >= 1),

CONSTRAINT CHK_STU CHECK(STATUS IN ('Approved', 'Pending', 'Denied'))

);

/** LET'S ALLOW NULL VALUES IN THE AUTHORISED DATE, AS we might not as yet have an

authorised date**/

ALTER TABLE EVENTREQUEST

MODIFY

(

DATEAUTH NULL

);

--7 EVENTPLAN

CREATE TABLE EVENTPLAN(

PLANNO VARCHAR(12),

EVENTNO VARCHAR(12),

WORKDATE DATE NOT NULL,

NOTES VARCHAR(1000) NOT NULL,

ACTIVITY VARCHAR(500) NOT NULL,

EMPNO VARCHAR(12),

CONSTRAINT PK_EVP PRIMARY KEY (PLANNO),

CONSTRAINT FK_EVP_EVR FOREIGN KEY (EVENTNO) REFERENCES EVENTREQUEST

);

/*ALLOW NULL VALUES IN NOTES COLUMN*/

ALTER TABLE EVENTPLAN

MODIFY

(

NOTES NULL

);

-- 8 EVENTPLANLINE

CREATE TABLE EVENTPLANLINE(

PLANNO VARCHAR(12),

LINENO INTEGER NOT NULL,

TIMESTART DATE NOT NULL,

TIMEEND DATE NOT NULL,

NUMBERFLD INTEGER NOT NULL,

LOCNO VARCHAR(12),

RESNO VARCHAR(12),

CONSTRAINT PK_EVPLL PRIMARY KEY (PLANNO, LINENO),

CONSTRAINT FK_EVPLL_EVP FOREIGN KEY (PLANNO) REFERENCES EVENTPLAN,

CONSTRAINT FK_EVPLL_LOC FOREIGN KEY (LOCNO) REFERENCES LOCATION,

CONSTRAINT FK_EVPLL_RES FOREIGN KEY (RESNO) REFERENCES RESOURCETBL

);

After creating

November 27, 2016 No Comments

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

Entity Relationship Diagram – ERD and Cardinality Symbols Simple Explanations

Superset Caravel BI Tool Installation and Visualizations on Heroku

Populating Superset Caravel MySQL database tables with Data via Heroku

Merry Christmas :) !!!

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

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

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

Free Entity Relationship and Relational Schema Diagram Tool

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

DataPandas LTS

EXPLORE DataPandas

ImportAnt link

GET IN TOUCH

© 2024 DataPandas