Sometimes Python gives You a hard time when You deploy code to a server after you changed directory structures or simply moved files. With the following command You can remove the pyc files in the working directory and subdirectories: find . -name \*.pyc -delete
The Essence of Machine Learning A pattern exists The pattern cannot be described mathematically We have data on this problem
This episode is about the basic statements needed to create, read, update and delete data in a database system. It is part of my SQL-Tutorial Motivation Let’s assume we work as a data scientist for Knight Industries. We want to help the Foundation of Law and Government to keep track of our operatives. We decide…
Sometimes your RDBMS does not allow you to do certain changes like updating a table without using a WHERE clause that uses a key column. When you are really sure what you want to do: SET SQL_SAFE_UPDATES = 0; Now the dirty brown magic can begin! Back to the SQL-Tutorial
Sometimes You screw up your database design and you have redundancies i.e. your database is not normalized. If You want to correct that: Subqueries for the rescue! In our example we have two tables which contain almost the same information: CREATE TABLE installed_device (`id` int, `device` text, `info` text); INSERT INTO installed_device (`id`, `device`, `info`)…
You can comment your queries with — This is a comment in SQL SELECT * FROM my_table — WHERE id = 1