Microsoft Visual C++ 9.0 is required

When I want to install packages, including Jupyter, I get the error that Microsoft Visual C++ 9.0 is required. I get the same error with Pip and pre-compiled binaries on UC website. I have Visual Studio 17 express installed and I have manually added the path of vcvarsall to my environment. I also saw solution to update … Read more

Removing numbers from string

Would this work for your situation? This makes use of a list comprehension, and what is happening here is similar to this structure: As @AshwiniChaudhary and @KirkStrauser point out, you actually do not need to use the brackets in the one-liner, making the piece inside the parentheses a generator expression (more efficient than a list … Read more

How do I pass JavaScript variables to PHP?

You cannot pass variable values from the current page JavaScript code to the current page PHP code… PHP code runs at the server side, and it doesn’t know anything about what is going on on the client side. You need to pass variables to PHP code from the HTML form using another mechanism, such as … Read more

Simple way to calculate median with MySQL

In MariaDB / MySQL: Steve Cohen points out, that after the first pass, @rownum will contain the total number of rows. This can be used to determine the median, so no second pass or join is needed. Also AVG(dd.val) and dd.row_number IN(…) is used to correctly produce a median when there are an even number of records. Reasoning: Finally, MariaDB 10.3.3+ … Read more