Python | Python 2.7 Install PIP

-
PIP is not prepackaged with Python 2.7 and I found that PIP is very helpful to install lots of python modules. So thought why not document the steps to install it. So here it is.

Install pip - Straight Forward way 

  1. Download the get-pip.py from https://pip.pypa.io/en/latest/installing.html
  2. Run this on command line - python get-pip.py
If you face any problems like "unable to fetch bla bla..." it is likely that you are having a proxy issue. If so follow the below steps

Install pip with Proxy config

  • Find the proxy config- i.e IP and PORT.
    1. if you already know it, then use that OR
    2. Go to your browser and check the proxy settings ( IE= Tools->Internet Options -> connections Tab -> Lan Settings. chrome= settings-> advanced options -> under Network -> "change proxy settings"). If your setting has "automatic proxy detection" then use the below method to find it.
    3. Open command line and type - "ping wpad" and see you can figure proxy settings. OR
    4. Open command line and type - "Ipconfig /all" and see if you can see the proxy settings OR
    5. from step-4 get the value for "Primary Dns Suffix". Open a browser and type - http://wpad.<Primary Dns Suffix>/wpad.dat. This should the wpad.dat file to you download dir. open the file and you should be able to get the proxy IP address and its port
  • Now on the command line set the environment variables.
    • set http_proxy=<proxy IP>:<Proxy Port>
    • set https_proxy=<proxy IP>:<Proxy Port>
  • Now run this on command line - python get-pip.py

Comments

Post a Comment

Popular posts from this blog

Tableau - Accessing Tableau's DB

-
Image
Click here for other Tableau related Blogs Please note that TABLEAU does not advice anyone to access their DB. So if you are doing it you are on your own. Tableau has 2 DB Postgresql for managing all its reporting repositories FireBird for mapping repositories Tools Required pgAdmin 3 for PostgreSql Flamerobin for FireDB Accessing Tableau's PostgreSQL DB Tableau has 2 buitin userid tableau = with read-only access to some of Tableau's view tblwgadmin = admin user will all privileges Please note tblwgadmin is like a admin user, so if you are using this you have to be very careful. Or if you dont admin privs but just need enough access to read the tables then use just "tableau" user. Get access for "tableau" user.  First set a password for "tableau" userid open command prompt go to <Tableau_Home>\Tableau Server\7.0\bin run -  tabadmin dbpass <give a password> Restart the server Now open pgAdmin3 and from...
Read more

Tableau : Convert ESRI shapes into Tableau Format

-
Image
Click here for other Tableau related Blogs Requirement is to convert data in ESRI Map shapes into Tableau format. Tools Required Quantum GIS -  http://www.qgis.org/en/site/ Python  Download the below Python Code -  https://github.com/venkat-vs-id/python import csv import re import sys #def convertESRI2TableauFormat( p_inputfile, p_outputfile): l_outfileName = 'c:/ESRI_suburb_tab_format.csv' # make changes here.. l_ESRIFileName ='c:/ESRI_suburb.csv' # make changes here.. rdx=0 csv.field_size_limit(sys.maxsize) outfile = open( l_outfileName, 'w', newline='') csvWriter = csv.writer( outfile, delimiter=',', quotechar='"', quoting=csv.QUOTE_MINIMAL) with open( l_ESRIFileName, 'r') as csvfile: csvR = csv.reader( csvfile, delimiter=',', quotechar='"') for row in csvR: rdx += 1 ci=0 rowValues = [] rowValues.append(row[1]);# ssc_code rowValues.append(...
Read more

Tableau: Convert Oracle Spatial Data into Tableau Format

-
Click here for other Tableau related Blogs I had requirement to shapes we had in Oracle Spatial data( which we used for MapInfo) in Tableau. Since tableau doesnt support Oracle spatial type columns, I had to extract that data in Tableau readable format. Here are the steps to convert oracle spatial data into format useable by Tableau. Run the Oracle package ven_OraSpatial_2_TabData in your oracle environment. Now run the below "ConvertDataFormat" code to extract the data into Tableau format Now use extracted data in tableau ( refer to my blog -  Tableau Maps - Custom shapes / polygon - Basics ) You can also download the code from this link -   VEN_ORASPATIAL_2_TABDATA.zip Oracle package ven_OraSpatial_2_TabData SPEC CREATE OR REPLACE PACKAGE VSUBR.ven_OraSpatial_2_TabData as ----- TYPE TYPE rec_LatLong IS RECORD( Polygon_ID NUMBER, LAT NUMBER, LON NUMBER ); TYPE tab...
Read more