Python and Pandas > Excel for anything outside of exploratory spreadsheet-y like calculations (I work frequently with 200k rows + of data, I _had_ to learn Python as Excel was too slow eventually and broke...now having a programming language to do formulae, I can't go back for any of my production processes, using excel now mostly for pivot tables and exploratory analysis (Excel is pretty awesome at that)
Hiya! I'm a cofounder of Mito [1] - where a spreadsheet extension to Jupyter Notebooks / Lab. Our most used feature is our exploratory graphing and Excel-like pivot tables - which seems super relevant.
Totally no pressure (although this is clearly a pitch), but if you get the chance to check it out and have feedback on where we fall short of being as awesome as Excel, your feedback would be super appreciated!
Well, yes and no - nothing can compete with Excel in terms of modeling speed and agility. A capable analyst can do miracles with Excel, find other routes to a solution, and then produced model can go to Python/Pandas developer for the processing optimization.
...Of course, you need to do professional data manipulation (whether in Python or with a real database) for 200k rows of data. Excel is never meant for handling that amount of information
You could put that into a VBA formula, although it wouldn't be as fast unfortunately (as I learned when I tried simplifying excel formulae - which are _compiled_ whereas VBA I think is interpreted? - in any case, excel was like 50x faster for me).
I assume you have tried the '$' signs to see if they will help?
Thanks for reply. Yes, if it was just for Excel I'd make a user defined function that returned a text value. I wanted the formula to work the same on Libre/Open office and on Google sheets so I went for an actual spreadsheet formula. Actually, the ';' separator came from the LibreOffice version.
'$' signs for A1? I'd still need to search and replace for A1 each time I needed to convert an angle in a different cell but I take your point that I could move the output around more easily. Speed does not seem to be an issue (the rest of the spreadsheet has calls to trig functions by the score)
Not sure about the cross compatibility to Libre and Google, but in Excel at least, replace your cell references with INDIRECT() references. Then store the cell you want to calculate on in another cell…say A1 (literally just type C1 in A1). Then reference with INDIRECT(“&$A$1&”). Saves you the search and replace for A1. Also works great if you want to copy formulas across tons of columns and maintain the correct column header references as you can insert the INDIRECT reference into table notation.
Thanks for your reply. I am aware of the absolute cell reference notation and use it frequently when I have a set of constants (e.g. longitude, latitude, year, month, day, timezone &c) that are referenced in many formulas. However the situation in my post was the other way round sort of.
As a concrete example (just in case I've mis-understood the situation), I have the right ascension, declination and phase angle of Venus as decimal angles in cells G80, H80 and M80 and I want the output strings in cells F3, G3 and H3. I still need to search and replace the A1 cell reference in my original post for each of the formulas.
As the poster a couple levels above pointed out I could do this as a user defined function in VBA, but I wanted my daft spreadsheet to work on Libre/Open office and on Google sheets with little or no modification. Hence the chain of if statements and round() functions.
It gets called on all clicks (line 1, it’s a window-level click handler), then finds the link the click target is inside (line 2), and does nothing if it wasn’t inside a link (line 9).
(You might think that it should use .closest("a[href]") instead of .closest("a"), since a:not([href]) is not a link, but in that case, link.href === "", and so it fails the line 10 is-it-eligible-for-client-side-routing test. Note also that except for the “no href attribute” case, HTMLAnchorElement#href gives a full resolved URL, so <a href=""> will produce the document base URL.)
Fundamentally, there’s no such thing as an event handler that triggers only on links—you instead have to use a global event handler that starts by checking whether it’s being triggered on a link.
I do think, though, that woojoo666’s comment and my response are worth bearing in mind. In this specific situation, I think <Link> is not warranted and mildly better avoided; but in a similar situation where global behaviour wasn’t already forced, I would say to keep the separate component, rather than breaking behavioural encapsulation.
> There's one thing, you should redirect all the pages to one single endpoint in server side order to use "pushState". Otherwise it will return 404 when you hit the refresh button. If you don't own a server, you can support routing with hashtag "#" and listen to "onhashchange" event instead of "popstate".
Could you explain this one a bit more / maybe some example code I could borrow from? :)
I don't get it...this is a simple library that people can use without bringing in external dependencies. Of course it won't be as functional as React-Router - that goes without saying!!
I would say that a router that doesn't support url patterns, query parameters or state is basically useless for anything other than small static sites that in my personal opinion shouldn't have clientside routing.
This is a nice demonstration of how routers can work for people that are curious, but I would have a lot of concerns about it as production-worthy, especially because you're manually firing browser native events during periods that people generally wouldn't expect them to fire.
I'm saying this as someone that had to write a full clientside routing system for a bespoke web app - routing is very hard and full of edge cases.
As another user commented above: Reddit was a company, Usenet is owned by no one, you can create your own groups, share groups you like not only from you etc. Moderation on Usenet in some groups might have been strong but far from Reddit: on Reddit mods are "Gods", on Usenet mods can be pushed out simply contacting enough users via mail or some other group. They are not that powerful.
Also on Usenet scoring, killfiles etc are yours so you can ban my posts because you do not like them, but others will see them, while on Reddit if a mod ban someone it's for all or no one.
Spam on usenet was and issue because at that time antispam was not good as today, today we can filter spam enough, if just there is enough interested public. So far usenet is far from being dead, it's used by few to share mostly pirate binary contents like Radarr/Lidarr/Sonarr series. With commercial orgs. That's not usenet of course, but that's still possible and it's useful enough to prove it's strength and flexibility.
Just see another example: Popcorn Time. A super-success people have abandoned simply because instead of install an app most prefer going to streaming websites, not really because of legal actions or ban. ZeroNet is built on the same principle, it's legal, made to share websites, nearly no one seems to be interested again because they can find some place to write text hosted by someone else. Or: the issue is cultural not technical. People en masse do not comprehend the meaning of freedom so they ignore it until it's tangibly lost and at that time it's too late.
Against such phenomenon there is no technical solution, only social ones...
> Subreddits have kinda replaced usenet groups of old.
Ah, but USENet is decentralised, Reddit is not.
> Also how to handle spam, thats been a killer for usenet lately
Last time I checked, the spam still being posted on USENet is Zombie-spam by long forgotten bots. A strong kill-list in a good client should easily minimise that problem.
There has been a revival of USENet by the smolnet and Web 1.0 people - some of the groups are active with almost no spam.
You forgot the pirate part: Radarr/Lidarr/Sonarr/NZBGet/* or paid binary groups. A showcase of how usenet archaic arch is still far more powerful than modern web ones...
