IndexError: list index out of range in using fetch_pandas_all() on Snowflake

Ah, my favorite type of error: sporadic! A day days we started getting failures when using fetch_pandas_all() against Snowflake. The query was a basic 'SELECT *' against an analytical data set. Here is the trace: Traceback (most recent call last): File "/Users/david/path/test/", line 31, in <module> df = cs.fetch_pandas_all() File "/Users/david/path/.scriptenv/lib/python3.8/site-packages/snowflake/connector/", line 978, in fetch_pandas_all... Continue Reading →

How does your vote count in the Electoral College based on where you live?

This article is a collaboration with my daughter, Meghan Bailey. Each state gets an allotment of electoral college votes based on their population. States with a higher population get more electoral votes such as Texas' 38 (based on July 2019 estimated population of just under 29 million). Those states with a smaller population are allotted... Continue Reading →


Today, President Trump tweeted out an image of a map with county shapes that looked Republican red. I was curious where this map originated from. There was an article back in 2016 by the Washington Post that provided some perspective. This was by county, the 2016 election results. However, the FLAT red county level map doesn't... Continue Reading →

Powered by

Up ↑