two columns

Python

Python Pandas Pivot Table Index location Percentage calculation on Two columns

Bydatapandasadmin October 5, 2016October 23, 2016

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 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;")

engine = sqlalchemy.create_engine('mssql+pyodbc:///?odbc_connect=%s"' % params)

resoverall = engine.execute("SELECT * FROM FlightBookingsMain")

df = df(resoverall.fetchall())

df.columns = resoverall.keys()

except (RuntimeError, TypeError, NameError):

print('Error in Conneccting')

print(RuntimeError, TypeError, NameError)

finally:

print("connected")

connected

In [164]:

1 2	#lets check the head df.head()

Out[164]: First Name Last Name Sex Phone Fax Email Address Booking Date Departure Date Arrival Date Address1 … Number of Passengers…