Durchsuchen nach
Schlagwort: CSV

To import a CSV file into a MariaDB database

To import a CSV file into a MariaDB database

Here is a little script to import a CSV file into a database. But it is not for a server. This is a standalone program. If you want to program it for a server, then you should use another method as with getpass, because getpass is waiting for an input. It is not useful, that you should enter every time a passport if you want to automate the process. If you downloaded a CSV file from the internet, and you…

Weiterlesen Weiterlesen

Read out the Gas level from a CSV file with Python Pandas

Read out the Gas level from a CSV file with Python Pandas

The fill level of Germany’s gas storage facilities is currently very low. Too low for the situation at the end of January 2026. These levels were actually expected to be reached by the end of March. Unfortunately, the German government’s website is very slow to update the fill levels of our gas storage facilities, even though they should be updated daily. I suspect the fax machines are malfunctioning again, or too many errors are being made between the tablet and…

Weiterlesen Weiterlesen

Python Pandas Query greater than

Python Pandas Query greater than

If you have a script with Python Pandas and you want to have a query for a value that is in my case greater than 40, then you have to use this kind of command. Make sure that you have installed Python and Pandas on your computer. The CSV file is from Google Trends, and I have asked Google Trends how many search queries are there for Python Pandas all over the world. At the moment, I’m building a tool…

Weiterlesen Weiterlesen

My own flipchart flashcards with HTML, Tailwind CSS and CSS3

My own flipchart flashcards with HTML, Tailwind CSS and CSS3

After answering those Google questions yesterday, I wanted to save the flashcards. Gemini tells me that as long as the chat exists, the flashcards will be accessible. But that seems too risky to me because I couldn’t delete the chat; there could be some kind of problem with Google’s servers, or I might even get blocked by Google. Therefore, I set out to have something of my own. Gemini offered me the option to save the data via Google Sheet,…

Weiterlesen Weiterlesen

Julia: How to show a CSV-file

Julia: How to show a CSV-file

Julia is a modern, high-level programming language designed for technical computing, excelling in fields like scientific research, statistics, data analysis, and machine learning. In this post, we’ll cover the essential first steps: how to successfully read a CSV file into Julia. Setup: Installation and Package Management Like in Python you need packages, that you have to install it. After installing Julia, you go to the command prompt and type in Julia. Then you see on the left side the word…

Weiterlesen Weiterlesen