How to run a SQL query on an Excel table?

There are many fine ways to get this done, which others have already suggestioned. Following along the “get Excel data via SQL track”, here are some pointers. Excel has the “Data Connection Wizard” which allows you to import or link from another data source or even within the very same Excel file. As part of Microsoft Office … Read more

JavaScript: filter() for Objects

Never ever extend Object.prototype. Horrible things will happen to your code. Things will break. You’re extending all object types, including object literals. Here’s a quick example you can try: Instead create a function that you pass the object.

Truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all()

The or and and python statements require truth-values. For pandas these are considered ambiguous so you should use “bitwise” | (or) or & (and) operations: These are overloaded for these kind of datastructures to yield the element-wise or (or and). Just to add some more explanation to this statement: The exception is thrown when you want to get the bool of a pandas.Series: What you hit was a place where the operator implicitly converted … Read more

Truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all()

The or and and python statements require truth-values. For pandas these are considered ambiguous so you should use “bitwise” | (or) or & (and) operations: These are overloaded for these kind of datastructures to yield the element-wise or (or and). Just to add some more explanation to this statement: The exception is thrown when you want to get the bool of a pandas.Series: What you hit was a place where the operator implicitly converted … Read more