Programming in Data Science

Learn about and discuss programming for data science

  • 12 Topics
  • 31 Replies

12 Topics

SorchaGilroy
SorchaGilroyCommunity Manager
published in Programming in Data Science

Purpose of this section

Welcome to the Programming in Data Science part of the Community 👋Some ideas for discussion for this section: New technologies that people are using and finding useful in their data science work Questions on how to use a particular programming language or technology, for example how to use ggplot in R for making charts or how to use Docker Sharing of resources you find elsewhere that might be of use to the community And anything else relevant to programming in data science!

100
SorchaGilroy
2 months ago
ChrisBillingham
ChrisBillinghamCommunity Manager
asked in Programming in Data Science

I want to smash a data.frame/tibble in R

Hey,So in R I have a tibble that is 1 x 9 and what I want to do is basically take those 9 variables and move them out of the tibble and become their own, free, variables.Aka I want to turn something like:df <- tibble::tibble(a = 1, b = 2, c = 3)intoa <- 1b <- 2c <- 3Without having to either individual put each variable into a new one witha <- df$ab <- df$bc <- df$cThings I have tried:tibble::deframe(df)unlist(df)Is there like a single function somewhere that can do this or do I have to faff about?

3
tomtom
1 month ago
E
EvolvingRichieActive Contributor
posted in Programming in Data Science

dbConnect() vs tbl() for reading data from AWS Redshift

Seems like to read data from Redshift I have (at least) 2 options: DBI::dbConnect(connection, ‘table-name’)vsdplyr::tbl(connection, ‘table-name’) The latter doesn’t read the whole table into memory and so you can perform all sorts of dplyr goodness on it before using collect() to read it into memory.Why would you ever use dbConnect() in that case?

2
SorchaGilroy
1 month ago
VanessaVirgo
VanessaVirgoFrequent Visitor
asked in Programming in Data Science

Let the debate begin... Python or R?

What do people prefer??

9
ChrisBillingham
2 months ago
lara
laraActive Contributor
asked in Programming in Data Science

Python explicit values for int variables

Is there a way to type a set of explicit values (that are of type int)? For example, I want to type that a variable can be from the set {0, 1, 2}?  (the numbers are actually mapped from constants)

1
S
2 months ago
lara
laraActive Contributor
asked in Programming in Data Science

Sklearn decision tree rules

Does anyone has/knows a library that extracts a sklearn decision tree into rules/present each rule with its number of samples? The idea is present small rules that have an impact on the likelihood of a customer returning and time between purchases.

2
lara
2 months ago
lara
laraActive Contributor
asked in Programming in Data Science

Logging in python

I’m having some trouble printing the logger in jupyter. I triedimport loggingfrom orion.utils.logging import IO_LOGIO_LOG.setLevel(logging.DEBUG)logging.basicConfig(stream=sys.stdout, level=logging.DEBUG)andlogging.basicConfig(filename='example.log', filemode='w', level=logging.DEBUG)but I don’t get anything!

0
lara
2 months ago
CurtisIrvine
CurtisIrvineCommunity Member
asked in Programming in Data Science

Hubspot Python Wrapper

Does anyone have any resources for hubspot API wrappers in Python?

3
L
2 months ago
RebekahYates
RebekahYatesActive Contributor
posted in Programming in Data Science

When creating plots in RStudio to be used in a presentation, how do you export them?

I’m interested in knowing how people typically save their plots from RStudio. Are there any ways you’ve found to be super quick and easy, or alternatively anything that should be avoided? E.g. maybe a certain way always skews the dimensions.Would be great if you could vote on the poll below so I can see what the most commonly used method is!

5
H
2 months ago
T
TomCommunity Member
asked in Programming in Data Science

How to make shiny plots interactive

Has anybody had functionality in a shiny app before where if you hover over a plot then you can see the value of the x and y axis at that point?

5
H
2 months ago
A
AndyLauCommunity Member
posted in Programming in Data Science

What are best practices for writing user defined functions in R/Python?

Writing a simple function is fairly straightforward. However, this often isn’t robust enough to share around say. What are best practices in terms of messaging, checks, code commentary etc etc? I look forward to any answers!!

0
A
2 months ago
lara
laraActive Contributor
asked in Programming in Data Science

Reading xlsx files in python

I might be missing something obvious here but I can't find any info -- can anyone help me to read a .xlsx file from S3 to python? I know how to do it for csv files, but not xlsx.

1
TomGrundy
2 months ago

Badge winners

Show all badges
Terms & ConditionsCookie settings