Python - Working With Conda

Python - Working with Conda

Getting Conda Environment Info

$conda info

$export PATH=”/app/miniconda3/bin:$PATH”

$source activate [env_name]

How to get Module installed path

>>>import module

>>>print(module.__file__)

Export Modules to file

$conda list --explicit > env_name.txt

Listing Environments

$coda env list

Creating New Environment

$conda config --add channels conda-forge #after this we can get file ~/.condarc

$vi condarc #set proxy in condarc file

~/.condarc

channels:

- conda-forge

- defaults

proxy-servers:

http:http://company.com

https:http://company.com

$conda create --name [env_name] --file env_name.txt

Installing miniconda by logging as root

#cat /etc/wgetrc #add proxies to wget for http,https,fttp

http_proxy=

https_proxy=

fttp_proxy=

#wget https://repo.anaconda.com/miniconda/Miniconda3-latest-Linux-x86_64.sh -O /app/miniconda3/miniconda.sh

root@server:/app/minconda3 #sha256sum miniconda.sh

root@server:/app/minconda3 #bash miniconda.sh

Installing google cloud sdk (https://cloud.google.com/sdk/docs/install)

root@server:/app #tee -a /etc/yum.repos.d/google-cloud-sdk.repo <<EOM

>[google-cloud-sdk]

>name=Google Cloud SDK

>baseurl=https://packages.cloud.google.com/yum/repos/cloud-sdk-el7-x86_64

>enabled=1

>gpgcheck=1

>repo_gpgcheck=1

>gpgkey=https://packages.cloud.google.com/yum/doc/yum-key.gpg

> https: ://packages.cloud.google.com/yum/doc/rpm-package-key.gpg

> EOM

root@server:/app#yum install google-cloud-sdk

$conda create -n gcp_38 python

$source activate gcp_38

To get packages from Python

>>>import pip

>>>for pkg in pip.get_installed_distribution(local_only=True):

… print(pkg)

$pip freeze or $conda list

In Pandas to get all columns displayed use below

>>>import pandas as pd

>>>pd.set_option(‘display_max_rows’,None)

Comments

LookML

What Is LookML? LookML is a language for describing dimensions, aggregates, calculations, and data relationships in a SQL database. Looker uses a model written in LookML to construct SQL queries against a particular database. LookML Projects A LookML Project is a collection of model, view, and dashboard files that are typically version controlled together via a Git repository. The model files contain information about which tables to use, and how they should be joined together. The view files contain information about how to calculate information about each table (or across multiple tables if the joins permit them). LookML separates structure from content, so the query structure (how tables are joined) is independent of the query content (the columns to access, derived fields, aggregate functions to compute, and filtering expressions to apply). LookML separates content of queries from structure of queries SQL Queries Generated by Looker For data analysts, LookML fosters DRY style...

Data Warehouse 101 - Part 2

Traditional Data Warehouse Concepts A data warehouse is any system that collates data from a wide range of sources within an organization. Data warehouses are used as centralized data repositories for analytical and reporting purposes. A traditional data warehouse is located on-site at your offices. You purchase the hardware, the server rooms and hire the staff to run it. They are also called on-premises, on-prem or (grammatically incorrect) on-premise data warehouses. Facts, Dimensions, and Measures The core building blocks of information in a data warehouse are facts, dimensions, and measures. A fact is the part of your data that indicates a specific occurrence or transaction. For example, if your business sells flowers, some facts you would see in your data warehouse are: Sold 30 roses in-store for $19.99 Ordered 500 new flower pots from China for $1500 Paid salary of cashier for this month $1000 Several numbers can describe each fact, and we call these...

A Deep Dive Into Google BigQuery Architecture

Introduction Google’s BigQuery is an enterprise-grade cloud-native data warehouse. BigQuery was first launched as a service in 2010 with general availability in November 2011. Since inception, BigQuery has evolved into a more economical and fully-managed data warehouse which can run blazing fast interactive and ad-hoc queries on datasets of petabyte-scale. In addition, BigQuery now integrates with a variety of Google Cloud Platform (GCP) services and third-party tools which makes it more useful. BigQuery is serverless, or more precisely data warehouse as a service. There are no servers to manage or database software to install. BigQuery service manages underlying software as well as infrastructure including scalability and high-availability. The pricing model is quite simple - for every 1 TB of data processed you pay $5. BigQuery exposes simple client interface which enables users to run interactive queries. Overall, you don’t need to know much about underlying BigQuery architecture or...

A Journey to Data Architect ..

Search This Blog