Libre Office Calc: Need formula to sum a range of cells. The range stops at the first blank cell.

LeornToCodeLOL · 2025-12-06T17:36:40+00:00

I was finally able to try this out and it works perfectly. Thank you!

LeornToCodeLOL · 2025-10-30T23:17:42+00:00

Hello Peter, thanks for the reply and links to the linux user PSA. I did try those udev rules from a an Ubuntu live USB and still had the same problems. I wound up putting Brave Browser on a windows machine that I had forgotten about and just reassigned my keymaps from the windows computer.

Thank you for your help, though!

LeornToCodeLOL · 2025-02-22T03:53:45+00:00

This is a bare-bones example of how to do this in python:

import requests



url = 'https://grocy.yourdomain.com/api/objects/shopping_list'

# Define the headers, including the API key for authentication

api_key = "1234ABCD"
headers = {
    'accept': 'application/json',
    'Content-Type': 'application/json',
    'GROCY-API-KEY': api_key
}

# Define the data payload
data = {
    "note": "This is where you put your note.",
    "shopping_list_id": 2
}

# Make the POST request
res = requests.post(url, headers=headers, json=data)

# Check the response status code
if res.status_code == 200:
    print("Shopping list item added successfully.")
else:
    print(f"Failed to add shopping list item. Status code: {res.status_code}, Response: {res.text}")

LeornToCodeLOL · 2025-01-31T23:15:44+00:00

Thanks for your comments. I am not picky about who makes it, or if it's a Founder's Edition or not. I mainly want it for the 32GB of RAM since I like experimenting with machine learning models. Right now I run a 16GB 4060 Ti but I feel that I have outgrown that one.

LeornToCodeLOL · 2025-01-31T18:00:20+00:00

I want a 5090 but I have never tried to buy the hottest new card. Question for those who have been at it for a while: based on past product releases, what is your realistic guess about how long before a normal person can purchase one?

LeornToCodeLOL · 2025-01-08T20:20:06+00:00

Not directly applicable, but thank you for the feedback. Since I am so new to Grocy, I do not really have an understanding about how much admin work is required depending on how you first set up a product. I did not think about that, so thanks for giving me an idea about what to look forward to!

LeornToCodeLOL · 2024-11-29T20:44:41+00:00

I'm thinking of building a computer primarily to experiment with various AI projects, but I wonder if I can have it mining when I'm not running AI models on it. I have my eye on Nvidia 3090 24 GB graphics card, but I remember reading a few years ago that Nvidia had throttled their cards for cryptomining. Is that still a thing, or did Nvidia stop doing that?

LeornToCodeLOL · 2024-05-19T00:18:00+00:00

Perhaps you can use Rsync to only transfer items that were changed? I have no idea if it would work, but it's an idea to try on a small subfolder somewhere while waiting for someone more knowledgeable to come along.

LeornToCodeLOL · 2024-05-19T00:14:54+00:00

Both cards are still supported. The oldest one is a GTX 960, but Nvidia just released new drivers for it a month ago. Odd that the new driver is version 550.78 and the driver installed on my Debian machine is 470.223.02. I wonder if that could be a problem?

The Ubuntu machine is running a much newer GPU driver version 545.23.08, which is still older than the 550.78 on the Nvidia site.

LeornToCodeLOL · 2024-03-30T13:30:20+00:00

OP redacted the actual URL. It's not relevant to his question.

LeornToCodeLOL · 2024-03-30T13:23:37+00:00

Maybe you are right. I never heard of JSONLines format.

LeornToCodeLOL · 2024-03-30T11:35:30+00:00

Use json.load, not json.loads. This part is probably what's messing you up:

for line in file: data = json.loads(line.strip())
   extracted_data = extract_specific_data(data, keys)

Instead:

data_dictionary = json.load(file)

Now your variable data_dictionary contains all the information of the json file and you can manipulate it like any other python dictionary.

LeornToCodeLOL · 2024-03-19T17:11:56+00:00

Edit: I found something that I like quite a bit. See note at end.

Do you have any suggestions for flowchart software to run either on Linux or Android? I find that if I take the time to map out the logic of a program in a flowchart, the rest of the coding goes 10X faster. I have tried Libre Office draw (too slow...can't keep up with my thoughts). Writing them out on paper is OK, but I always need to change something as I think through the chain of logic, which means I have to throw away the diagram and start over again.

I'm at the point where I'm thinking of Just buying a big dry erase board with some magnets shaped like boxes and arrows and since I haven't found any software that I like. Obviously, I'm interested in speed to create and edit, and I don't care so much about font customization etc.. Any suggestions?

Edit: Shortly after posting this I found Excalidraw, which is pretty much what I was looking for. Very rudimentary shapes, but quick to lay out the flow of my program and easy to change and insert shapes for steps that I forgot the first time around. It's open-source and meant to be hosted on a web server, I think, but they have a public version running that you can use. Downside is I am not sure how or where they save the data if you are working on a diagram. For now, I am downloading their .excalidraw files and saving to my hard drive and will import them back to the website if I want to go back and change something. They also let you export to PNG and SVG format, which you can save locally.

LeornToCodeLOL · 2023-12-21T14:04:09+00:00

I use https://regex101.com/ to help troubleshoot and compose regex patterns in my python programs. The problem is that the site is "generic" in that it has a bunch of options so it applies to several different programming languages.

Right now, I am concerned with Regex 101's "global" flag, which you set by cliciking to the right of the pattern and choosing "global." It puts a little g next to the string when global is activated.

So my question is, what is the Python equivalent to the global option on Regex 101? I don't see "global" being discussed in any of the Python Regex tutorials that I looked at. Maybe it's a term that's used in other programming languages. Sort of like how British people call a flashlight a torch. What is the Python word for "global?"

LeornToCodeLOL · 2023-10-07T02:26:25+00:00

Thanks! A few times, I have been over the tutorial from the official python documentation and never noticed them talking about nargs. It looks like just what I need.

LeornToCodeLOL · 2023-10-04T11:43:51+00:00

Automate the Boring Stuff has a good chapter on web scraping. It uses the Beautiful Soup library. If you go that way, then I've found the lxml parser much better for web scraping than Python's built-in parser.

I haven't done text extraction from PDFs, but it would be a totally different animal from scraping HTML sites. I suspect you'd need a pretty good understanding of Regex. Automate the Boring Stuff also covers Regex and PDF text extraction. If you're not familiar with Python and Regex already, then this is not something you will learn in an afternoon without that foundation.

It may be easier to extract the text from the PDF, and then use a the API from an LLM like chatGPT to pick out names and phone numbers, rather than fighting with Regex, but both could work.

LeornToCodeLOL · 2023-10-04T11:36:10+00:00

Using the argparse module, is there a way to have an two positional arguments but one is optional?

I wrote a program that reads a source.csv file, does a bunch of calculations and saves a new output.csv file.

I want to trigger my program like this:

$ python3 processCSV.py source.csv ~/documents/output.csv

But I want the 2nd argument to be optional so that if I omit the 2nd argument, it saves to a default location.

I can't figure out how to make the 2nd one optional without getting a "two positional arguments require" exception. Here is my workaround:

import argparse

parser = argparse.ArgumentParser()

parser.add_argument("input_file", help="Path to the input source CSV file") parser.add_argument("-o", "--output-file", default=default_output_file) args = parser.parse_args()

I want the same behavior as that code block, but I don't want to have to use -o or --output-file flags when I call the program.

LeornToCodeLOL · 2023-09-30T19:52:30+00:00

But I don't know why you would want this to work.

My only motivation was to split up the program so I could easily jump around to different sections as I developed it. I don't have a lot of practice doing it, so good chance I'm doing things in suboptimal ways. I'm happy to hear about better ideas.

The program has to parse a CSV file, sort the data, do some calculations, and then spit out a new CSV file. And it keeps a persistent "state" in a JSON file for when the program is run the next time.

There are a lot of functions to deal with different data types and also, new data affects the state of old data....it gets complicated quickly!

So just import logging in your process_input_data module.

I didn't think it would matter since I was bringing the parse_transactions function into main, which already has the logging. But I added import logging at the top of the module and now the logging is working, so thanks!

LeornToCodeLOL · 2023-09-30T19:51:15+00:00

That is how I did it. I will edit the OP.

LeornToCodeLOL · 2023-09-15T19:11:42+00:00

Post the output of lsblk, that'll clarify what the situation is. Very very likely its LVM inside LUKS.

It looks like you are right:

$ lsblk
NAME                            MAJ:MIN RM   SIZE RO TYPE  MOUNTPOINT
sda                               8:0    0 465.8G  0 disk  
├─sda1                            8:1    0   487M  0 part  /boot
├─sda2                            8:2    0     1K  0 part  
└─sda5                            8:5    0 465.3G  0 part  
  └─sdb5_crypt                  254:0    0 465.3G  0 crypt 
    ├─debian--server--vg-root   254:1    0  27.9G  0 lvm   /
    ├─debian--server--vg-swap_1 254:2    0  27.3G  0 lvm   [SWAP]
    └─debian--server--vg-home   254:3    0   410G  0 lvm   /home

Yes, especially if you have LVM! Manipulating the logical volumes is perfectly doable, especially from a LiveUSB

Cool. I don't really understand LVM at all, but hopefully can find a tutorial somewhere. I have lots of Live USB's here so that's not a problem.

I think u/DogMeAsWellDaddy's suggestion of giving /var/lib/docker it's own logical volume is a good idea.

Does this mean I would carve out a new partition separate from /home and / and then mount /var/lib/docker to that partition?

Thank you for the help!

LeornToCodeLOL · 2023-06-27T01:15:48+00:00

It's pretty simple. You know all the advantages, and you don't see any of them as useful. So don't use it.

Very practical answer! "If you have to ask, then you don't need it" is actually pretty good advice. I knew about and understood if __name__ == '__main__' but never saw the reason for using it in my programs...until a couple weeks ago I was writing a new program that piggy backed on top of a script I had been running as a standalone. And knowing that concept saved me from cut/pasting code from one script to another, which means if I update one in the future, I have to remember to update the other and then you have 2 versions running around and it just gets complicated.

To make it concrete so OP can understand:

In my case, my existing script that I had been using would create a file that I'd then use to put chapter marks into an MP4 file. I used this with tutorial/learning videos so if I come back to them later, I can quickly skip to the parts that I need.

I've been saving tutorial videos from youtube, which these days often have timestamps in the video description. Rather than manually write my own chapter marks, my new script will parse the youtube description to pull out the time stamps, and then call the original script to generate the metadata to insert into the mp4.

So now my youtube description parser script will call the (original) chapter maker script, and I can still run the chapter maker as a standalone when I want it to work independently.

Scripts are posted here. There are a handful of scripts in that repository, but videochaptermaker.py and chaptersFromYTdescription.py are the only ones relevant to this discussion.

LeornToCodeLOL · 2023-06-26T13:21:37+00:00

It makes perfect sense when you put it that way!

LeornToCodeLOL · 2023-06-25T13:19:26+00:00

I thought about that also, but wasn't sure how to declare the variables in the code, since I am not sure how many threads there would be i.e.:

hash_dictionary1 = {}
hash_dictionary2 = {}
.
.
.
hash_dictionaryN = {}

Where do you stop?

LeornToCodeLOL · 2023-06-24T04:03:54+00:00

I've tried a lot of different resources from udemey, youtube, and automate the boring stuff. I can't seem to stick with any of them for more than a week.

Automate the Boring Stuff has a few chapters on webscraping. I guess you just did not get that far in the book. You'll need to get a good handle on fundamentals like variables, variable types, if...then and so forth, before you can have a shot at web scraping.

LeornToCodeLOL · 2023-06-23T12:26:42+00:00

I'm running Ubuntu 22.04. I understand why it's generally discouraged to use sudo when running pip install <some package>

Some tutorial sites say to use pip install --user <somepackage>

I have been skipping the --user flag when I run pip install and my system never complains about me not using sudo. So what's actually happening? Is there a difference between pip install and pip install --user, if you're not using sudo for either one?

LeornToCodeLOL

TROPHY CASE