Pandas DataFrame

Putting Python Pandas DataFrames Together

If you have worked with Pandas for any length of time you have probably come across the need to stick a dataframe together with another dataframe.  It turns out it’s not as simple as you might think.

I’m going to show you a couple of ways to accomplish putting one or more dataframes together in Pandas depending on the situation and desired results.


pandas for python

Python Pandas Prolonged

The other day I posted a Pandas for Python Primer . I promised a follow up before the end of the week; and away we go…

Pandas for Python, A Slight Return

Previously I talked about creating DataFrames, their rows and columns, and how one might apply a function to them. In my experience, more often than not you’ll want to import some data. You start by importing Pandas of course. A note here – by convention some coders import Pandas as pd. You’ll want to replace my pandas. to pd. if you are doing this.


Pandas for Python

In my continuing education / love affair with Python I have moved past the basics. I have started exploring the rich Python ecosystem, and my latest fascination is Pandas.

What is Pandas for Python?

Pandas for Python helps coders with data manipulation and analysis. It offers data structures and operations for manipulating numerical tables and time series. It’s free software released under a BSD license.


I Got The News

I Got The News

Darling if you only knew, half as much as everybody thinks you do…
— Donald Jay Fagen / Walter Carl Becker

Yes, yet another Python project named after a song.

Unlike Where It’s At, this data collection project is named after an unfortunate Steely Dan disco meets doobie brothers song called I Got The News on the otherwise stellar Aja album…


Democratic Candidates 2020 March Madness

Democratic Presidential Candidates 2020 – March Power Rankings

I am super excited to announce the March Madness edition of the 2020 Democratic Candidates Power Rankings!

I’ve invested over 20 hours into my rating system since last month’s version  ran.  In February I ranked the chances of 2020 potus candidates regardless of party.

This month it is strictly Democrats.  The new version of my system is much slicker and contains a couple of totally new metrics.


February 2019 Power Rankings

NBA Power Rankings February 2019

I have recently been inspired to write code of interest to the legal sports book industry again.  Disclaimer – I have nothing to do with placing bets, taking bets, money exchanges for bets, or anything else to do with actual betting.

What I am almost obsessed with is sports betting odds, probabilities, rankings, etc.  Of course when this kind of data is turned into information it can be of great value to the sports betting industry…


2018 House Mid-Term Predictions

2018 House Midtem Election Predictions

The Democrats will take back the house on Tuesday, November 6, 2018.

There is no blue wave however and it will be closer than many pundits are predicting.  I have predicted all 435 house races, with the help of Python, Pandas,  SciKit-learn, etc.

There are a handful of races that will tell the tale, but my model is predicting that it is going to be a difficult two years coming up for Donald J Trump.