@stevensanderson@mstdn.social
@stevensanderson@mstdn.social avatar

stevensanderson

@stevensanderson@mstdn.social

New Book: https://packt.link/oTyZJ | R - install.packages("healthyverse") | #SQL | opinions are mine | #rstats | Mainly though my wife and kids :) | Advisor to DoTadda - All posts delete in 12 months.

This profile is from a federated server and may be incomplete. Browse more on the original instance.

stevensanderson, to RegEx
@stevensanderson@mstdn.social avatar

I decided to make a blog post out of a problem I worked on a day or two ago and thankfully I was also pointed to another solution from @embiggenData which worked well too.

#R

Post: https://www.spsanderson.com/steveondata/posts/2024-04-12/

image/png
image/png

jromanowska, to ai
@jromanowska@fosstodon.org avatar

Will this new AI model from Google make programmers useless?! https://youtu.be/SSnsmqIj1MI

stevensanderson,
@stevensanderson@mstdn.social avatar

@jromanowska No I don't think so at all, if anything it will help them explore their creativity more, it will help for more rapid prototyping

stevensanderson,
@stevensanderson@mstdn.social avatar

@jromanowska technological change will always be made, we have to adapt

stevensanderson,
@stevensanderson@mstdn.social avatar

@jromanowska feed and water people and the planet, that's just silly talk. Nuclear is useful but the US hates it so much when other countries use it

stevensanderson,
@stevensanderson@mstdn.social avatar

@jromanowska it’s obviously not silly talk i was being sarcastic, i agree with you, if we don’t take care of ourselves and our home we are going to go the way of the Dino

stevensanderson,
@stevensanderson@mstdn.social avatar

@jromanowska It is, I agree with that

craigbrownphd, to technology
@craigbrownphd@mastodon.social avatar

##Technology #tech #DataAnalytics #Cloud #DataIntelligence #ArtificialIntelligence #MachineLearning #ML #CloudIntelligence Future of LLM application development – impact of Gemini 1.5 Pro with a 1M context window, https://www.datasciencecentral.com/future-of-llm-application-development-impact-of-gemini-1-5-pro-with-a-1m-context-window/?utm_source=dlvr.it&utm_medium=mastodon #DataScience #BigDataAnalytics #AI

stevensanderson, (edited )
@stevensanderson@mstdn.social avatar

@craigbrownphd I'm thinking of signing up for this. I typically do a lot of coding questions (Copilot which i pay for via github) but I also do a lot of writing, idea/image generation and ideas.

How would you rank Gemini Advanced, GPT Plus and Copilot Pro

How would anyone else out their rank them?

stevensanderson, to datascience
@stevensanderson@mstdn.social avatar

Today's post is the complement of yesterdays, instead of filtering out rows, let's get the ones we want :)

#R

Post: https://www.spsanderson.com/steveondata/posts/2024-04-11/

stevensanderson, to Glue
@stevensanderson@mstdn.social avatar

Some one just reached out looking to extract values from a cell that are produced by from the

Example a cell value like 251 (13%) they just want the 251, so I did something like this:

library(tidyverse)
tibble(
value = glue::glue("{11:20} ({1:10}%)"),
reged_val = str_extract(value, "\d+(?=\W|$)") |>
as.numeric()
)

A tibble: 10 × 2

value reged_val
<glue> <dbl>
1 11 (1%) 11

Thoughts?

#R

stevensanderson,
@stevensanderson@mstdn.social avatar

@gavin im not sure how the person wants data to come out but that is an elegant solution

stevensanderson,
@stevensanderson@mstdn.social avatar

@gavin can also do the following:

library(tidyverse)

reg_val_fns <- function(.col_data, .pattern = NULL){
ptrn <- .pattern
if(is.null(ptrn)){
ptrn <- "\d+(?=\W|$)"
}

reged_val <- .col_data |>
str_extract(ptrn) |>
as.numeric()

return(reged_val)
}

tibble(
x1 = "Unit A",
x2 = glue::glue("11 (12%)"),
x3 = glue::glue("23 (34%)"),
x4 = glue::glue("45 (7%)")
) |>
mutate(across(-x1, reg_val_fns)) |>
mutate(total_val = rowSums(across(-x1)))

stevensanderson,
@stevensanderson@mstdn.social avatar

@embiggenData oh cool didn’t know that one

stevensanderson, to python
@stevensanderson@mstdn.social avatar

Feeling stuck with Excel for data analysis?

My new book which was co-authored by David Kun, Extending Excel with Python & R, shows you how to leverage the strengths of BOTH worlds!

Here's what you'll gain:
🧐 * Advanced data manipulation & cleaning
💻 * Powerful statistical analysis & modeling
📉 * Eye-catching data visualizations
🌟 * Seamless integration back to Excel

The release date is April 30th!

#R

Link: https://packt.link/oTyZJ

stevensanderson,
@stevensanderson@mstdn.social avatar

@hyp3r00t I will ask the publisher. As far as a course, I don't know really. I did not think about it.

stevensanderson, to datascience
@stevensanderson@mstdn.social avatar

Looking to do some data filtering in base R? Well then of course I have a post for you! Many times people in a corporate environment are strapped from installing packages or it is cumbersome to get it done, this is why I like to focus on base R solutions.

#R #RStats #RProgramming #Coding #DataScience #Data #DataScientist #Programming

Post: https://www.spsanderson.com/steveondata/posts/2024-04-10/

image/png

davidbraze, to random
@davidbraze@mstdn.social avatar

Do you really think MS takes better care of your company's data than they do of their own?

"a (Microsoft) server ... exposed passwords, keys, and credentials of Microsoft employees to the open internet, as the company faces mounting pressure to bolster its software security. "

https://www.theverge.com/2024/4/10/24126057/microsoft-azure-server-internal-passwords-exposed-cybersecurity

stevensanderson,
@stevensanderson@mstdn.social avatar

@davidbraze typical MS

mikemathia, to food
@mikemathia@ioc.exchange avatar

stevensanderson,
@stevensanderson@mstdn.social avatar

@mikemathia oh but what if it's no good, someone might get sued! well that's what we get for being so litigious and frankly gross in our behavior

stevensanderson, to datascience
@stevensanderson@mstdn.social avatar

Got NA's in your data? Well, if you want to get rid of them then this post is for you!

#R

Post: https://www.spsanderson.com/steveondata/posts/2024-04-09/

stevensanderson,
@stevensanderson@mstdn.social avatar

@Mehrad I’ll do that, thanks!

stevensanderson, to datascience
@stevensanderson@mstdn.social avatar

Need some practice on merging data in #R well then this post is for you. It is not an exhuastive post but hopefully you learn something :)

#R

Post:https://www.spsanderson.com/steveondata/posts/2024-04-05/

image/png
image/png
image/png

stevensanderson, to datascience
@stevensanderson@mstdn.social avatar

Merging data in R? Yes you can!

Post: https://www.spsanderson.com/steveondata/posts/2024-04-05/

#R

stevensanderson, to random
@stevensanderson@mstdn.social avatar

Need to visualize and scale multi-dimensional data? Well sometimes we do and this post is for you!

Post: https://www.spsanderson.com/steveondata/posts/2024-04-04/

#R

stevensanderson,
@stevensanderson@mstdn.social avatar

@sf99 pos option

stevensanderson,
@stevensanderson@mstdn.social avatar

@sf99 you’re welcome to

stevensanderson, to languagelearning
@stevensanderson@mstdn.social avatar

Yesterday I posted the code I am working on in the attached, so what does it do?

Well its in the blogpost: https://www.spsanderson.com/steveondata/posts/2024-02-02/

#sql #dataquery #data #query #language

image/png

stevensanderson,
@stevensanderson@mstdn.social avatar

@yvz i dont have that function available to me i ended up doing an outer apply

  • All
  • Subscribed
  • Moderated
  • Favorites
  • •
  • JUstTest
  • GTA5RPClips
  • magazineikmin
  • InstantRegret
  • thenastyranch
  • cubers
  • Youngstown
  • ethstaker
  • slotface
  • mdbf
  • rosin
  • Durango
  • kavyap
  • DreamBathrooms
  • megavids
  • khanakhh
  • tacticalgear
  • ngwrru68w68
  • cisconetworking
  • modclub
  • everett
  • osvaldo12
  • normalnudes
  • provamag3
  • anitta
  • tester
  • Leos
  • lostlight
  • All magazines
    •