Posts by Jiri Pik

Career Advice for a 20-Year-Old

A friend asked me to talk to his son about how to choose a university and his career. These notes, always under construction, is the key advice. General Advice Always do the most difficult thing you can do. Be extremely…

On Books Reading

We have been fighting on this planet for ten thousand years; it would be idiotic and unethical to not take advantage of such accumulated experiences. If you haven’t read hundreds of books, you are functionally illiterate, and you will be…

Exploring Code of Hands-On Financial Trading w/ Python with DataSpell

JetBrains DataSpell is JetBrains new IntelliJ-based (the same engine as in JetBrains PyCharm) IDE for Jupyter Notebooks. The principal difference between PyCharm and DataSpell is the focus – PyCharm is an IDE for general Python development and DataSpell is an…

On Employment Screening Tests

Nowadays, the trend is to use computer-based tests to provide “a rich view of the candidates’ abilities“. However, the quality of these tests varies dramatically, and the hiring managers may not be aware of the typical problems with the tests.…

Jiri Pik’s New Book “Hands-On Financial Trading with Python”

I am very proud to announce the book “Hands-On Financial Trading with Python” written with Sourav Ghosh and published by Packt Publishing on April 29, 2021. The book is available for purchase at amazon.com and at packtpub.com. Front Cover Back…

Excel vs. Python – when to use Excel and when to use Python?

1. Summary While some authors claim that “Python is the new Excel”, we believe that Excel is the right tool for handling not large amounts of structured information and performing basic interactive data analysis. Excel workbooks serve the role of…

How to Set Up the Latest Version of PostgreSQL on AWS Linux 2

Although AWS does provide their own RDS service for running PostgreSQL I recommend it only (1) if you frequently require restoring the database up to a particular minute’s snapshot and (2) if the CPU usage of the database server would…
keyboard_arrow_up