gcp_python_spreadsheets

Solved: “The caller does not have permission” – Using the API with a private Google Spreadsheet

  • by

Ahh, user rights. The cause and solution to all of life’s identification problems. In this blog post I explain how you can access (private) google spreadsheets using the Python gspread library. Before you get started: make sure you have administrator rights to the spreadsheets you are trying to work with.… Read More »Solved: “The caller does not have permission” – Using the API with a private Google Spreadsheet

a-field-guide-to-lies-and-statistics

“A Field Guide to Lies and Statistics”: arm yourself against bullshit and data overload

  • by

In his book “A Field Guide to Lies and Statistics”, psychologist Daniel Levitin elaborates on some commonly made mistakes when it comes to interpreting data. Although a lot of the topics are closely related to the chapters from the best-selling 1960’s booklet “How to lies with Statistics” by Darrell Huff,… Read More »“A Field Guide to Lies and Statistics”: arm yourself against bullshit and data overload

pivot-vs-pivot_table-pandas

Pandas’ pivot_table vs. pivot

  • by

When you’re an R poweruser, pivoting tables in pandas feels unnecessarily complex. Why are there two pivot functions? Why does it return an index when you wanted a column? Why does it generate multi index columns? Those are the questions I tackle in this blog post. To answer some questions… Read More »Pandas’ pivot_table vs. pivot