Author: datapandasadmin

Simple Interactive Google Data Studio Dashboard
| |

Simple Interactive Google Data Studio Dashboard

Google has now made Data Studio accessible and you can use it to create pretty cool data visualizations. You can find out more about the free versions and the premium versions here. Google Data Studio In the meantime, you can view a simple dashboard I created for Amazon Product Sourcing here: Amazon product Sourcing Google Studio…

| |

Save Multiple Pandas DataFrames to One Single Excel Sheet Side by Side or Dowwards – XlsxWriter

  This tutorial is just to illustrate how to save Python Pandas dataframe into one excel work SHEET . You can save it column-wise, that is side by side or row-wise, that is downwards, one dataframe after the other.   In [110]: import sqlalchemy import pyodbc from pandas import DataFrame from bokeh.plotting import figure, output_file, show…

|

Save Python Pivot Table in Excel Sheets ExcelWriter

Untitled This is a quick script on how to save Python pivot_table in an excel file. Credit to  pbpython In [1]: import sqlalchemy import pyodbc from pandas import DataFrame import pandas as pd   In [2]: df = DataFrame ## connect to SqlServer Database and get information. try: import urllib params = urllib.quote_plus(“DRIVER={SQL Server Native Client 11.0};SERVER=.\MSSQLSERVER_ENT;DATABASE=Antrak;Trusted_Connection=yes;”)…

Python Pandas Pivot Table Index location Percentage calculation on Two columns

pivot table for year on year This is a quick example of how to use pivot_table,  to calculate year on year percentage sales . In [162]: import sqlalchemy import pyodbc import numpy as np from pandas import DataFrame from bokeh.plotting import figure, output_file, show import pandas as pd   In [163]: df = DataFrame ## connect to…

Python Bokeh plotting Data Exploration Visualization And Pivot Tables Analysis

This is a quick walk through Bokeh data exploration and visualization and also python pivot_tables (credit to pbpython on the pivot_tables).Visualization Dashboard In [49]: import sqlalchemy import pyodbc from pandas import DataFrame from bokeh.plotting import figure, output_file, show import pandas as pd   In [50]: df = DataFrame ## connect to SqlServer Database and get information. try: import…

Python PyQt Gui Basics Button Window PyQt4 Pt1

This is just some quick scrap notes on the basics of Python GUI building using PyQt. In [1]: import sys from PyQt4 import QtGui, QtCore # to help add buttons #app = QtGui.QApplication(sys.argv) # #window = QtGui.QWidget() # ##set the posstion and size of the window #window.setGeometry(50, 50, 500, 500) # ##lets set the title #window.setWindowTitle(‘Date…

Basic Plotting Using Bokeh Python Pandas Library – Scatter, Line Visualizations

  Bokeh is a powerful framework for data visualization in Python. Here I take a look at straightforward plotting and visualization using this powerful library. Credit to PythonHow. You can check him out on Youtube bokeh.models #It is a low level interface which involves a lot of work bokeh.plotting # It is a middle level interface bokeh.chart #…

Structured Pyramid Analysis Plan SMART GOAL Data Analysis

The key advice for any Data Analysis project is to never start any analysis without first having a structured plan. You should set your goals and they should be S.M.A.R.T   Below are the two charts to help with Analysis. This is part of Data Visualization and Communication with Tableau  by Duke University on Coursera. Set your…

| |

Machine Learning Hypothesis function Cost function and Gradient Descent Algorithm Short Notes

  This is a short scrap notes from the Machine Learning Course taught by Associate Professor,  Andrew Ng,  Stanford University on Coursera.  hypothesis = hØ(x) + Øo + Ø1X Parameters = Øo , Ø1 Our Goal = minimise Ø0 , Ø1 that is the cost function J(Ø0, Ø1) GRADIENT Descent. An algorithm wich minimises the…