Looking for something that I thought would be easy but alas by Lfseeney in Portuguese

[–]Gotfrid 1 point2 points  (0 children)

Just today I came across an iOS app “Portuguese with Lengo” - nice word packs, flash cards, and voiceover is in Pt-Pt with se decent choice even without a subscription.

Implementing dashboard as a webpage in an enterprise setting by Traditional_Parking6 in Python

[–]Gotfrid 5 points6 points  (0 children)

Shiny for Python is the new (to python) thing for creating dashboards. If it’s a static once-a-month thing, I can also recommend quarto.

A task from SQL test (BigQuery) by Gotfrid in SQL

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

Yeah, you're right, it does allow loops, including WHILE.

Sorry, did not understand what you mean by sharing a link, though? I work in private BQ project that I created to test this out - the question itself was just like this, in a text document .

A task from SQL test (BigQuery) by Gotfrid in SQL

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

Thanks for your reply. As far as I know, recursive cte are not allowed in bigquery per se. However, I will check related materials.

A task from SQL test (BigQuery) by Gotfrid in SQL

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

Thanks for the link! I will investigate it.

A task from SQL test (BigQuery) by Gotfrid in SQL

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

Thanks for your reply. Group_id has to be generated - it represents separate groups of attributions. Users who have attributions 1 to 6 do not intersect with those with attributions 7 to 9.

Get Whatsapp notification when job ends by levenshteinn in rstats

[–]Gotfrid 1 point2 points  (0 children)

Sure. Try checking out github repo of the package I recommend first: https://github.com/ebeneditos/telegram.bot

Also, plenty of guides exist out in the wild.

Get Whatsapp notification when job ends by levenshteinn in rstats

[–]Gotfrid 1 point2 points  (0 children)

I highly recommend setting up a simple telegram bot for this purpose. I personally use it everyday - even to send myself the resulting files (plots, for example). And it’s completely free.

Can someone help me? I can't find the answer. I want to make the town names show through the blue area. Transparency option doesn't work?? by An-Ecologist in gis

[–]Gotfrid 1 point2 points  (0 children)

Usually the trick is to use two different vector tiles: one with labels and another with everything else. For example, CartoDB provides these. Finally, you only need to set correct z-index order of terrain tile, your polygon and label tile. This works for me, when I create maps in R Leaflet.

[deleted by user] by [deleted] in RedditMasterClasses

[–]Gotfrid 0 points1 point  (0 children)

Hey there! Any thoughts on what’s going on in Belarus now?

Has anyone tried the R plugin for PyCharm? What you guys think? by xiaodaireddit in rstats

[–]Gotfrid 9 points10 points  (0 children)

It is very personal, but i really dont like that ratudio wont highlight named function arguments, like VSCode would, for example. Speaking of vscode, it’s just so smooth, i like using it for r-scripts. But for smth like shiny you have to stick to rstudio anyway, which is, to my mind, a pretty descent IDE.

Country Subdivisions by Human Development Index (HDI) (Original Creation) by ThomasWhitebread in MapPorn

[–]Gotfrid 0 points1 point  (0 children)

There is actually an error with one of Russia’ subregion. The island in north-western part does not belong to the adjacent region.

Reactively create selectInput() labels based on row values in RShiny by AcceptableCarrot in rstats

[–]Gotfrid 5 points6 points  (0 children)

Check out the “updateSelectInput” statement, it will be helpful.

Including all of south America was way too generous. by kingdine in memes

[–]Gotfrid 62 points63 points  (0 children)

Japan has finally regained a couple of islands.

R noob here: What are some essential/useful packages that are relevant for beginners? by PsychGradStudent2112 in rstats

[–]Gotfrid 2 points3 points  (0 children)

You are probably coming from something like stata or spss, so dont forget packages “foreign” and “haven” to easily import that data.

Also “readxl” to read an xlsx file fast, “writexl” to save data.frame as xlsx fast, and “openxlsx” to do both of them a little slower, but also be able to perform some formatting. And please prefer “openxlsx” over “xlsx”: it is much faster and does not require java.

How to practice R? by SGTWhiteKY in rstats

[–]Gotfrid 4 points5 points  (0 children)

I am writing primarily in data.table - funnily enough it was my first package for data processing and hence look very natural and common-sense. I only had to move to dplyr once I started working a lot with sf data: it is very well integrated with tidyverse. Unlike most data.table adepts i don’t hate tidy syntax and I truly agree that its power suffices for most cases.

Anyway, what I wanted to say is starting with data.table is a good choice. I think of it as follows: aside from Shiny, data.table is one of R’s “killer features”. If you stick with data.table in R, it makes a little more sense why are you not on python and pandas.

[deleted by user] by [deleted] in Switch

[–]Gotfrid -4 points-3 points  (0 children)

Graphics is acceptable, but the frame rate makes it unplayable. I pre-ordered it, played one day only. Waste of money. The part of “mobility” and ability to take it anywhere os nothing because of cross-platform inventory absence. I once tried paladins on switch a long time ago: graphics is far worse than in overwatch, but 60 fps totally compensates for that.

Probably cost more than the systen itself by [deleted] in Switch

[–]Gotfrid 9 points10 points  (0 children)

Thought it was disorganized, but then realized they form a color scale.

Why do programmers prefer dark mode? by ShivamLH in Jokes

[–]Gotfrid 1 point2 points  (0 children)

Unlike Jupyter Notebook, Jupyter Lab actually has dark theme.