PinnedFinn AnderseninITNEXTThe fastest way to read a CSV file in Pandas 2.0It turns out that the fastest way to create a Pandas DataFrame from a CSV file is to use an entirely different library.Apr 15, 2023Apr 15, 2023
PinnedFinn AnderseninITNEXTThe ultimate guide to Panda’s read_csv() functionHere I unravel the mysteries behind the omnipotent and overwhelmingly complicated read_csv() function, including new features added in 2.0Mar 30, 2023Mar 30, 2023
PinnedFinn AnderseninITNEXTHow to Scale a Monolithic Django Project — Without MicroservicesExploring ways to architect a growing Django project so that it’s easy to maintain and can handle high user load.Mar 3, 20232Mar 3, 20232
PinnedFinn AnderseninITNEXTHow to Create Your Own Custom Pandas Extension TypeHere I will explore how Pandas uses Extension Types to address NumPy’s limitations, and walk through an example of how to create your own.Jan 17, 2023Jan 17, 2023
Finn AnderseninDev GeniusAnalyzing and Optimizing Database interactions with Django and pyodbcRecently I performed some investigation into the database interaction activity of the Django-based data platform I lead in order to detect…Mar 5, 2022Mar 5, 2022
Finn AndersenI made a Retro Gaming System from an Old Vintage TelevisionNow it has a second life helping me relive the old classics from the pastApr 2, 2020Apr 2, 2020
Finn AndersenDemystifying middleware in Django’s request-response cycleI dived into Django’s source code to create a comprehensive diagram describing every step of Django’s request-response cycle through all…Sep 13, 2018Sep 13, 2018
Finn AndersenA Simple Python Class for Formatting Table Data to Display in HTML or CSVDisplaying content from a database table on a web page is a common requirement, however often the way the data is stored in the back-end…Aug 27, 2018Aug 27, 2018
Finn AndersenI Made a Custom Handheld Retro Gaming ConsoleUsing a Wii-U Pro controller, Raspberry Pi and a 3D printed enclosure. It can emulate games from N64, PS1, SNES, GBA and more!Aug 19, 20181Aug 19, 20181