Happy May Day!
DataPandas wishes you Happy International Workers’ Day!
Want more information like this?
Similar Posts
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]:
Default1234import sqlalchemyimport pyodbcfrom pandas import DataFrameimport pandas as pdIn [2]:
Default12345678910111213141516171819202122df = DataFrame## connect to SqlServer Database and get information.try:import urllibparams = 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")Default1connectedIn [8]:
Default1df.head()Out[8]: First Name Last Name Sex Phone Fax Email Address Booking Date Departure Date Arrival Date Address1 … Number of Passengers Total Cost Currency Numeric Code…
Can the sample size be equal to the population size?
What is population size: In simple terms, let’s us say population is the WHOLE SET and What is sample size: let us say it is the SUBSET (which is within the whole set) The norm Normally subsets are within the whole set and are smaller than the whole set Can they be equal ? Yes…
Happy Weekend To You All
Happy Weekend To You All From The DataPandas Team 🙂 Want more information like this?
Coursera Capstone Final Report – Data Analysis and Interpretation
I worked with a World Bank Dataset provided by the Course instructors. The research question was: Prediction of Adjusted Net National Income Per Capita of Countries Brief Introduction to the Research Question The purpose of this project was to identify the best predictors for Adjusted Net National Income Per Capita of countries from multiple World…
Merry Christmas :) !!!
Want more information like this?
Rank Sort Series DataFrames in Python Pandas Numpy
In this quick notes, we will have a look at Rank and Sort in Series and DataFrames in Python In [1]:
Default123import numpy as npimport pandas as pdfrom pandas import Series, DataFrameIn [3]:
Default123#make a seriesser1 = Series(range(3), index=['C','A','B'])ser1Out[3]:
Default1234C 0A 1B 2dtype: int32In [4]:
Default12#sort index of seriesser1.sort_index()Out[4]:
Default1234A 1B 2C 0dtype: int32In [5]:
Default12#order or sort by valuesser1.order()Default12C:\Users\adaba\Anaconda3\lib\site-packages\ipykernel\__main__.py:2: FutureWarning: order is deprecated, use sort_values(...)from ipykernel import kernelapp as appOut[5]:
Default1234C 0A 1B 2dtype: int32In [6]:
Default1ser1.sort_values()Out[6]:
Default1234C 0A 1B 2dtype: int32In [7]:
Default1from numpy.random import randnIn [8]:
Default123#make a series by passing in 10 random numbersser2 = Series(randn(10))ser2Out[8]:
Default12345678910110 -0.2017511 1.5341092 0.5428253 1.4211744 -0.1737715 0.0025736 -0.4902087 -0.7653408 -2.5460409 -0.456699dtype: float64In [10]:
Default12#sort the valuesser2.sort_values()…