IT Handyman

Because sometimes you need a little help…

Menu
Skip to content
  • Home
  • About / Contact information
  • Dulare uses…

Tag: Python

Python rounding issue and how to fix it
  • Python

Python rounding issue and how to fix it

  • Posted on 2022-01-052022-01-27
  • by dulare

Consider the following piece of code: The code above produces the following output: Strange, isn’t it? The values which end with “5” should be rounded up! This is a common…

Read More
Pivot pandas dataframe – convert row to columns (and join this to the rest of the other dataframe)
  • Python

Pivot pandas dataframe – convert row to columns (and join this to the rest of the other dataframe)

  • Posted on 2021-12-292022-01-27
  • by dulare

In my previous post, I wrote about the quick way to generate Excel export from the database using Python. This was a simple report, but in fact, I had to…

Read More
Excel report from the database – the quick way in Python
  • Python

Excel report from the database – the quick way in Python

  • Posted on 2021-12-222022-01-27
  • by dulare

If you are thinking of a quick way to prepare an Excel report from the data you have in your database, you can use Python. In order to achieve this,…

Read More
Don’t use “CALL StoredProcedure()” in Python :)
  • Python

Don’t use “CALL StoredProcedure()” in Python :)

  • Posted on 2021-12-152022-01-19
  • by dulare

This issue is related to MySQL (I’m using mysql-connector-python). Surprisingly, when I was changed my query to a stored procedure, my code stopped working. It looked like this: And it…

Read More
Disabling AWS CloudFront distribution using Python and Boto3
  • AWS

Disabling AWS CloudFront distribution using Python and Boto3

  • Posted on 2021-11-242021-12-09
  • by dulare

AWS CloudFront is a widely-used content delivery network service and as most of Amazon Web Services elements can be configured programmatically in many ways. For beginners, the easiest way leads…

Read More
Day-based videos for a large timelapse project
  • Python

Day-based videos for a large timelapse project

  • Posted on 2020-12-232021-01-18
  • by dulare

A few weeks ago, I started my security camera timelapse project which resulted in a lot of files being captured (my camera takes a photo every minute). I moved the…

Read More
Move many files to date-based directories
  • Python

Move many files to date-based directories

  • Posted on 2020-12-162021-01-18
  • by dulare

Here is the story: as the result of my security camera timelapse project, I ended up with a ton of files stored in a single directory. I want them to…

Read More
Simple AWS EC2 instance scheduler
  • AWS

Simple AWS EC2 instance scheduler

  • Posted on 2020-09-232020-10-14
  • by dulare

More than two years ago, I wrote a “how-to” post about the Amazon AWS Instance Scheduler that was based on the pieces provided by the AWS team. I notice that…

Read More
Reboot AWS instance on the failed status check
  • AWS

Reboot AWS instance on the failed status check

  • Posted on 2020-08-262020-09-23
  • by dulare

I know, I know, this is not the best practice. The instance should be configured so it will work properly and status checks will always pass. The problem is that…

Read More
Stop using print, start using loguru in Python
  • Python

Stop using print, start using loguru in Python

  • Posted on 2020-07-222020-07-23
  • by dulare

Yes, I know that the easiest way to receive some output from my Python script is to use a print statement. Nice and easy. But is it? It can be…

Read More

Posts pagination

Page 1 Page 2 Page 3 Next Page

Recent Posts

  • Sending emails from Docker using Postfix installed on the Host
  • Fuzzy search testing – using PostgreSQL compared to Qdrant vector database
  • OpenAI models fine-tuning considerations
  • Oxygen upgrade issue: Download failed. Unauthorized
  • OxyMade update failed – how to pull the license key from the database

Tags

3D printing administration Apache Arduino AWS ColdFusion databases development EC2 ESP8266 Express FriendlyTracker FTP git Handlebars IIS Infusionsoft IoT Java Javascript Linux Lucee Machine Learning MS SQL Server MySQL Node OpenAI OpenVPN programming Python Qdrant Security Selenium SQL SSL TestBox threads timelapse tips TLS Ubuntu vector database web development Windows WordPress
© Copyright 2025 – IT Handyman
Bezel Theme by SimpleFreeThemes ⋅ Powered by WordPress