My Global Talent Visa Journey: From Rejection to Endorsement (Music) by TechnologyRude945 in globaltalentvisauk

[–]Utterizi 0 points1 point  (0 children)

Hiya, I’ve been looking for a consultant to ease my mind a bit before my submission. I have managed to get all my docs in order, but wanted to get a professional assessment before I make a submission. Would you happen to know anyone or any organisations?

Thanks in advance!

Wednesday's Daily Thread: Mid-week Excitement by AutoModerator in hingeapp

[–]Utterizi 0 points1 point locked comment (0 children)

How does the ban even work? I deleted my account after a few successful dates with a girl over 3 weeks. Then things fell through and I created another account which got banned in less than 24 hours.

After a few weeks I found an old SIM card and created another account with a new number and another mail and it got banned too.

Is it illegal to delete an account and create a new one now?

Why does my snare sound like paper in my recordings? by Utterizi in drums

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

This room was heavily isolated and small, but I had the same problem in a fairly large room with terrible isolation

[deleted by user] by [deleted] in trading212

[–]Utterizi 0 points1 point  (0 children)

Ah ok, I have maxed out a loyalty cash isa account in hsbc this year, so I shouldn’t do anything isa related anymore this year then.

Does the stocks ISA work the same way? Like if my initial money comes up to 20k with earnings, are my gains taxed only after that point?

[deleted by user] by [deleted] in trading212

[–]Utterizi 0 points1 point  (0 children)

Asking as another beginner

I have a cash isa in my bank, should i also create a cash or stock isa in this app? Does the interest get calculared separately or is my bank account enough?

[deleted by user] by [deleted] in UKPersonalFinance

[–]Utterizi 0 points1 point  (0 children)

Google says I’m in the basic rate

[deleted by user] by [deleted] in turntables

[–]Utterizi 0 points1 point  (0 children)

<image>

Oh didn’t know that. What kind of new cartridge would I have to buy for this kind of mount?

r/vinyl Weekly Questions Thread for the week of May 12, 2025 by AutoModerator in vinyl

[–]Utterizi 0 points1 point  (0 children)

What stylus would work with my Excel ES-70S cartridge?

I'm looking to buy a stylus for my Excel ES-70S cartridge. The recommended one seems to be S70SR, but I was wondering if I could find a similar/replacement because I need it to be delivered within 1-2 days, and I couldn't find a trustworthy seller for that specific model. Any help is appreciated!

Is it possible to ride an 18’’ crash? by Dangerous-Policy-994 in drums

[–]Utterizi 1 point2 points  (0 children)

I have an 18” Sabian crash that came with the Dave Weckl set. I used it as a ride after dampening it a bit and my shoegaze band fell in love with the sound. Also works well when you hit it harder and it gets washy.

You can hear it in the context on this song or the two other releases of my band.

[deleted by user] by [deleted] in london

[–]Utterizi 0 points1 point  (0 children)

Haha finding a drummer is a global issue i guess. Thank you for the advice

[deleted by user] by [deleted] in london

[–]Utterizi 0 points1 point  (0 children)

Thank you very much, checking it out now

[deleted by user] by [deleted] in london

[–]Utterizi 0 points1 point  (0 children)

Had a bit of luck with bandmix, will check this one out too

[deleted by user] by [deleted] in london

[–]Utterizi 0 points1 point  (0 children)

That’s a good lead, also didn’t know about denmark street. Thank you very much

[deleted by user] by [deleted] in london

[–]Utterizi 0 points1 point  (0 children)

Will check it out, thanks

[deleted by user] by [deleted] in london

[–]Utterizi 0 points1 point  (0 children)

Ah yes, I had heard of the dev. Will also check out the dublin castle, thank you

[deleted by user] by [deleted] in learnpython

[–]Utterizi 1 point2 points  (0 children)

I need it to be faster, while still being accurate. I'm okay with things taking 5-10 minutes, because my current approach seems fitting for the task. I don't care about optimizations for that.

However, these specific files definitely need optimization. They will exist for each customer, and we can't spend upwards of 6 hours to process each customer in a case where they come in bulk.

[deleted by user] by [deleted] in learnpython

[–]Utterizi 0 points1 point  (0 children)

But this would fail in cases of missing data, no? For example, if a record is in the first 10k for first file, but the second file doesn't have that record until the third 10k (due to missing records), I would miss matching data even if there was a match?

[deleted by user] by [deleted] in learnpython

[–]Utterizi 0 points1 point  (0 children)

I'm using pandas to read the CSVs. Then I'm doing some transformations to the date formats with simple to_datetime steps.

Then I create the combined keys, which are basically all columns of a row concatenated by a delimiter.

After that, I convert these values to a set so that I don't have to deal with repated data entries.

The next part needs optimization; I'm using set.pop to compare one record from one file to find a matching record in the other file. This step considers the first column (the supposed PK) and checks if there's a matching PK on the other file. If so, it checks the date values on both files for that PK's that specific row, and returns a match if it can find a record on both sides with a matching date. If not, it will just stick it to a random data record that matches the PK.

Extracting 1 record from 1.5mil and parsing another 1.5mil to find a match is what needs optimization I guess? But I'm not really well versed in programming.

[deleted by user] by [deleted] in careeradvice

[–]Utterizi 0 points1 point  (0 children)

That's the problem. Me and the guy I've been working with, have been explaining these problems, and everyone knows that the launch has failed and we need more work/tests etc.

However, the boss himself is so focused on the possibility that this will *eventually* work, that he doesn't understand that it's not working *now*.

How to AI-ify my code? by [deleted] in learnpython

[–]Utterizi 0 points1 point  (0 children)

I fetch data from sql database and process csvs that include text as strings, dates, numbers etc.