Readit News logoReadit News
countmora commented on Like MS Excel, Pivot tables never die   rilldata.com/blog/why-piv... · Posted by u/articsputnik
epistasis · 4 months ago
It is the best, but also the very very worst in so many ways.

There are all sorts of data that are nearly impossible to get into Excel because of the ways that it tries to turn everything into a date. There has been so much silent data corruption because of random misfeatures that were added decades ago and now they will never back out of the system. The string OCT4 amongst a column of alphanumeric identifiers will get changed into a date, silently, on import, and it's nigh on impossible to find out how to import without that silent conversion. It's better to write your own Python code to get data into Excel than to use its built in foot guns.

countmora · 4 months ago
If you import with PowerQuery you can explicitly specify the data type for each column.
countmora commented on Like MS Excel, Pivot tables never die   rilldata.com/blog/why-piv... · Posted by u/articsputnik
stonecharioteer · 4 months ago
I wish more people explored Excel. Not just spreadsheets. But MS Excel. It is the best piece of software that came out of MSFT.
countmora · 4 months ago
I wish more people stop hating on Excel. It's an incredible tool with cool stuff baked in (Python support, PowerQuery, etc.). Just because some people misuse it as database or it doesn't scale well beyond a couple of 10k rows does not make it a bad product. For 90% of daily office tasks it's just fine.
countmora commented on IMDB Terminal Browser   github.com/isene/IMDB... · Posted by u/thunderbong
vidyesh · 6 months ago
It scrapes.
countmora · 6 months ago
Don't want to be that guy, but [1] says

>Robots and Screen Scraping: You may not use data mining, robots, screen scraping, or similar data gathering and extraction tools on this site, except with our express written consent as noted below.

[1] www.imdb.com/conditions/

countmora commented on Is my vision that bad? No, it's just a bug in Apple's Calculator   martin.wojtczyk.de/2024/0... · Posted by u/wojtczyk
DavidPiper · a year ago
Comically, I didn't even notice those wobbly numbers in the first screenshot, I was too busy noticing:

- "Unicode" button label way off center

- The 8/10/16 selector being off center in its own position

- The indicators for bits 31 and 63 are not aligned with each other

- x and + not being horizontally aligned (I believe this is an icon-font issue, seen on HN before so knew to look for it)

countmora · a year ago
> "Unicode" button label way off center

Its actually the center of the button, I made a video for context: https://imgur.com/a/1Y9O8dS

> The 8/10/16 selector being off center in its own position

Might be due to the image compression, it looks fine on my MB.

countmora commented on Spotify demonetizes all tracks under 1k streams   djmag.com/news/spotify-of... · Posted by u/buro9
snailmailman · 2 years ago
I don’t know much about how music licensing works. But would this cause smaller musicians to decide to pull their stuff off Spotify?

I listen to a lot of music on Spotify. And some of it is from smaller indie artists. Not a huge amount, but I’ve definitely listened to songs that are in that <1000 plays category, and for some undiscovered artists that’s a good amount of their library.

It surprises me how much of my Spotify library is no longer available. There’s at least a few dozen songs in my Spotify library that have been taken off the platform. It shows up in the list greyed out. A lot of good songs too.

As much as I love Spotify and music streaming, it seems like the economics of it fundamentally doesn’t work and can’t work.

countmora · 2 years ago
I think royalties from <1k streams are basically nothing anyway. Giving up the ability to distribute your music for free and reach more people would be a terrible idea.
countmora commented on Sora: Creating video from text   openai.com/sora... · Posted by u/davidbarker
countmora · 2 years ago
> We’re also building tools to help detect misleading content such as a detection classifier that can tell when a video was generated by Sora.

I am curious of how optimised their approach is and what hardware you would need to analyse videos at reasonable speed.

Deleted Comment

countmora commented on *@gmail.com   xkcd.com/2822/... · Posted by u/ufjfjjfjfj
countmora · 2 years ago
I was still curious about the exact response, therefore I see no harm in posting that.
countmora commented on Ask HN: Loud MacBook fan ruining my audio in meetings. Help?    · Posted by u/aunpansani
countmora · 3 years ago
If you have a newer macOS version on an entry Intel machine, ordinary tasks can cause a lot of fan noise. You can activate Low Power Mode [1] to reduce clock speed and therefore the fan will not be as loud. See if the reduced clock speed does not interfere with your daily tasks.

[1] https://www.howtogeek.com/771767/how-to-enable-low-power-mod...

countmora commented on Weird GPT-4 behavior for the specific string “ davidjl”   twitter.com/goodside/stat... · Posted by u/goranmoomin
GaggiX · 3 years ago
It's a subreddit where people count. There are a lot of comments, and unfortunately the tokenizer was trained on this subreddit, which is why these weird tokens.
countmora · 3 years ago
> unfortunately the tokenizer was trained on this subreddit

Do you have a source for that or was it just an assumption?

u/countmora

KarmaCake day88March 14, 2021View Original