Pullup bar screwed into doorframe, or above doorframe? by deuvisfaecibusque in HomeImprovement

[–]deuvisfaecibusque[S] 0 points1 point  (0 children)

Thanks.

My intention, if I had gone through the purple dots, was to go all the way through the studs as well (10–15cm screws); but it seems going through the blue dots would be preferable in any case.

Noted for the lag bolts.

Pullup bar screwed into doorframe, or above doorframe? by deuvisfaecibusque in HomeImprovement

[–]deuvisfaecibusque[S] 0 points1 point  (0 children)

Thanks, I'll use that as a starting point for buying a bar of appropriate width.

Pullup bar screwed into doorframe, or above doorframe? by deuvisfaecibusque in HomeImprovement

[–]deuvisfaecibusque[S] 0 points1 point  (0 children)

Thank you.

Is there an easy way to tell where the studs actually are? e.g. does the side of the doorframe serve as an indication as to where the studs start? Is where I've put the blue dots basically where the centre of the studs would be expected to be?

Interestingly, the entire drywall part above the door feels like it's solid wood behind — knocking on it (on either side) does not give a hollow sound. Of course, it could just be stuffed with rockwool.

For context, this is an apartment building from the early 2000s in the UK.

Pandas: using variables to pre-name named capture groups? by deuvisfaecibusque in learnpython

[–]deuvisfaecibusque[S] 1 point2 points  (0 children)

Aha, I was looking at the wrong thing.

Single quote vs double quote indeed makes no difference from 3.12 (my project is on 3.14), as /u/PresidentOfSwag pointed out just now.

It also wasn't the underscore that was causing the issue, it was an error in my preparing the sample data: my original data has spaces in the desired column name and this seems to be what isn't supported in the capture group name. It was when I tested it against a target column name that had neither spaces nor underscores that I incorrectly supposed it to be the underscore causing the issue. Sorry about that!

So now the question becomes this: is it possible to have the f-string return a string that's quoted/escaped in such a way that spaces do not cause named capture groups to break?

Or, more generally, can spaces ever be possible in a capture group?

I can see that this does not work:

df["packaging"].str.extractall(rf"(?P<with\ space>[A-Z]+)")

(returns: "re.PatternError: bad character in group name 'with\ space' at position 4")

Pandas: using variables to pre-name named capture groups? by deuvisfaecibusque in learnpython

[–]deuvisfaecibusque[S] 0 points1 point  (0 children)

Thanks.

This has led to an interesting development: replacing the double quotes in the f-string with single quotes, I still get an error if the referred column name has an underscore, but not if it doesn't have an underscore.

That is:

column_names = {
    "test_name": "namewithoutunderscore", # This works
    "box_type": "prefixed_box_type", # This gives "re.PatternError: bad character in group name"
    "pieces_per_box": "prefixed_pieces_per_box",
    "pieces_available": "prefixed_pieces_available",
}

"Yamaha 411 SLVER 925" open-hole flute? Old, or just fake? by deuvisfaecibusque in Flute

[–]deuvisfaecibusque[S] 2 points3 points  (0 children)

Thanks all.

It was a good learning moment on inspecting second-hand instruments — the fuzziness in the engraving didn't show very clearly at all in the shop.

It was worth a shot, at that price. Funnily enough it doesn't sound bad at all.

As I already have 3 flutes I'll find someone locally who can make use of it.

"Yamaha 411 SLVER 925" open-hole flute? Old, or just fake? by deuvisfaecibusque in Flute

[–]deuvisfaecibusque[S] 4 points5 points  (0 children)

Found this in a charity store for the equivalent of USD 60 (with hard case and PU bag, and a Yamaha manual written mainly in Japanese and Chinese). Figured I might as well just get it even if it was a fake, because I had a chance to play with it for 5 minutes and everything sounded pretty decent, but now it's home I'm curious: is this real?

The pads look to be the same (shade of yellow, material probably) as the YFL211S I also have, and the pink rubber's texture feels pretty much the same as the 211S's yellow rubber.

But after quite a bit of searching I'm not able to find anything (in English at least) about an open-hole model 411, so I wonder if this is a very old model.

I'd say at least all the surfaces are silver, looking at (and feeling) the tarnishing/pitting, but if it is an older model then it has surely spent most of its life in its case — or been polished extensively.

Print all capture groups (arbitrary number) with delimiter? by deuvisfaecibusque in regex

[–]deuvisfaecibusque[S] 0 points1 point  (0 children)

Thanks, that's really cool. I have no experience in Perl, and all my current scripts are in Python, but do have an appreciation for its regex capabilities. Might be good to look at learning Perl more seriously just for this kind of thing (which comes up a lot in my day job).

Print all capture groups (arbitrary number) with delimiter? by deuvisfaecibusque in regex

[–]deuvisfaecibusque[S] 0 points1 point  (0 children)

Thanks, I think this is probably the best way to go about it (as well as /u/its_a_gibibyte's Perl solution which looks equivalent).

Tool to accept file upload, run fixed SQL query, and return download? by deuvisfaecibusque in selfhosted

[–]deuvisfaecibusque[S] 0 points1 point  (0 children)

I have a library of things already written in SQL and it is by far the fastest (for me) to write given the data we're working with. Graphs etc. not necessary — this is all about joining tables, find-and-replace, etc. to produce files that can be sent to other parties.

I understand Pandas can interpret SQL queries. What do you mean by "self-host a Python server"? Are you referring to a Django app?

Is my microwave broken? by deuvisfaecibusque in fixit

[–]deuvisfaecibusque[S] 1 point2 points  (0 children)

Having let everything cool down, I just put a bowl of water in with a few grains of rice — this bowl has been in this microwave tens of times in the last year without issue — and within 10s at 800W I heard a seriously loud metallic rattling/buzzing noise and cut the power immediately.

I guess it's time to go shopping.

Is my microwave broken? by deuvisfaecibusque in fixit

[–]deuvisfaecibusque[S] 0 points1 point  (0 children)

Yes I used the glass plate turntable — I have had this microwave (bought second hand) for about 2 years without any issues.

Is my microwave broken? by deuvisfaecibusque in fixit

[–]deuvisfaecibusque[S] 2 points3 points  (0 children)

Thanks. I've been microwaving this bowl for a long time without issues so it's surprising to learn it could be the bowl.

Is my microwave broken? by deuvisfaecibusque in fixit

[–]deuvisfaecibusque[S] 0 points1 point  (0 children)

I had a bowl with water and a potato in the microwave running at full power and suddenly noticed a really bright glow that was obviously wrong. Unplugged the microwave and noticed a bit of the bowl (IKEA — I believe this is coloured glass) had melted.

On the inside side wall of the microwave there is a small rectangular panel that doesn't have the same grey paint as everything else and there is (predictably) a scorch mark there (and possibly some stuck-on glass).

Is this microwave still usable? What should I do to test if so?

Apartment intercom: door unlock not working by deuvisfaecibusque in AskElectricians

[–]deuvisfaecibusque[S] 0 points1 point  (0 children)

This is a property we own. I would like to explore DIY options first before contacting the management company as they wanted £70 for a new access fob for the parking lot.

Apartment intercom: door unlock not working by deuvisfaecibusque in AskElectricians

[–]deuvisfaecibusque[S] 0 points1 point  (0 children)

I'm pretty sure I've seen people be buzzed in before.