In SQL-Basics we learned the standard SQL statements to create a table, insert data into it, retrieving data from tables and altering data. Now we want to do even Devon is a data driven man and to evaluate our mission, he likes to know from us: how many missions we finished the total cost of…
import unicodecsv def read_csv(filename): with open(filename, ‘rb’) as f: reader = unicodecsv.DictReader(f) return list(reader)
In Distributing your own package on PyPi I wrote about my first package on PyPI. Here are some refinements aka lessons learned: Project Description on PyPI I wondered why the project description on PyPi was empty. Solution: You need a long_description. If You already have a README.md, you can read it into a string and…
When you finished reading part 1 of the introduction you might have wondered how to draw more than one line or curve into on plot. I will show you now. To make it a bit more interesting we generate two functions: sine and cosine. We generate our x-values with numpy’s linspace function import numpy as…
One of the things I always forget is date and time in Python. So message to myself: The strftime method is used for formatting (string_format_time) import datetime start_date = datetime.datetime.now() DATE_FORMAT = ‘%d/%m/%Y %H:%M’ print(start_date.strftime(DATE_FORMAT)) Her is a nice little Cheatsheet
Since Python 3.3 You can chain dictionaries which contain the same key in a prioritized order: from collections import ChainMap prio_1 = {“param_1”: “foo”} prio_2 = {“param_1”: “foobar”, “param_2”: “bar”} combined = ChainMap(prio_1, prio_2) print(combined[“param_1”]) # outputs ‘foo’ print(combined[“param_2”]) # outputs ‘bar’ The param_1 from the prio_1 dictionary is dominant, so it isn’t overwritten by…
<=> is the NULL-safe equals operator SELECT * FROM reports WHERE NOT driver <=> user_id
In my article My personal road map for learning data science in 2018 I wrote about how I try to tackle the data science knowledge sphere. Due to the fact that 2018 is slowly coming to an end I think it is time for a little wrap up. What are the things I learned about…
When you are working in an agile team e.g. Scrum you might have heard about the agile manifesto. Formulated in 2001 it influenced a lot of software developers and methodologies like Scrum. The Agile Manifesto consists of 4 values and 12 principles: Values Principles Our highest priority is to satisfy the customer through early and…
Big Data is a buzz word nowadays. But when is data “big data”? Three Vs of Big Data Big data spans three dimensions Volume Velocity Variety Volume Everything which doesn’t fit on your local hard drive anymore can be considered big. Think >10 TeraByte Velocity The more real time your data becomes the more you…