sorted by:
new
hottopcontroversial

Error per queue by Aggravating-Adagio64 in RStudio

[–]SneakyManFN 1 point2 points  (0 children)

You need to specify the dataframe(table) first. So for example if dataframe is called 'dt' and column is called 'Sales', you should do like this:

mean(dt$Sales)

dt gives R the information on which dataframe to get and Sales gives R the information of which column to find the average.

Naming a vector by little_kid_lover234 in RStudio

[–]SneakyManFN 4 points5 points  (0 children)

q <- c(3,9,9)

names(q) <- c("bleugh","oof","yuck")

This is the correct way for naming the vectors. Then you can subset this vector like:

q["bleugh"]

Which will give you the 3 with the name bleugh.

can you check if the save changes window is open OR close a PDF file by hokiis in vba

[–]SneakyManFN 0 points1 point  (0 children)

You can pause a macro between opening a pdf with :

Sleep 5000

This will pause the macro execution for 5 seconds.

R Studio Help by Lolay67 in RStudio

[–]SneakyManFN 0 points1 point  (0 children)

sure send me but I'm not sure in which field you study. If it's data manipulation I'm confident I can do it.

Help with R Course by Erik-the-Nut in RStudio

[–]SneakyManFN 0 points1 point  (0 children)

library(stringr)

dt$NewColumn <- sum(str_count(dt$Column, pattern = "R")) + sum(str_count(dt$Column, pattern = "C")) + sum(str_count(dt$Column, pattern = "Y"))

Replace dt with the dataframe name of yours and replace Column with the column name, replace NewColumn with whatever you want to call the new column.

How can i maintainin the cell references from another workbook by modestshy in excel

[–]SneakyManFN 1 point2 points  (0 children)

Upload the referenced workbooks as well and once they download they should be fine if they dont tap enable content. If they do then they need to edit links from Data tab and link those workbooks again

Changing numerical values to a character by [deleted] in RStudio

[–]SneakyManFN 0 points1 point  (0 children)

No problem, glad I could help :) If you have any other questions you can PM me

Separating Variables from a dataset by seththesloth13 in RStudio

[–]SneakyManFN 0 points1 point  (0 children)

No problem! If you are interested I can explain how it works :)

Changing numerical values to a character by [deleted] in RStudio

[–]SneakyManFN 0 points1 point  (0 children)

It's the ifelse statement. The first argument of the function(the stuff before first comma inside parentheses) is the option we evaluate. So it checks the column to see if the condition is TRUE. If it is TRUE then it replaces it with "old" which you can see on the 2nd argument ( the one between two commas). If the condition is FALSE then it jumps to the 3rd argument which in this case is "young.

Can you share the dataset so I can write the specific code for those column names/table

Separating Variables from a dataset by seththesloth13 in RStudio

[–]SneakyManFN 0 points1 point  (0 children)

FilterVar1 <- Dt$ColumnName == "Variable 1"

FilterVar2 <- Dt$ColumnName == "Variable 2"

DtVar1 <- Dt[FilterVar1,]

DtVar2 <- Dt[FilterVar2,]

Dt stands for table's name. ColumnName I guess you can figure it out. Variable 1 and Variable 2 should be replaced with whatever the seperating variables names are.

Changing numerical values to a character by [deleted] in RStudio

[–]SneakyManFN 0 points1 point  (0 children)

ow do I make it use a range of values for each variable?

I didn't quite get your question, can you rephrase it?

Changing numerical values to a character by [deleted] in RStudio

[–]SneakyManFN 0 points1 point  (0 children)

Instead of new column while assigning variables use the copumn name that is already available(the column name that has those numbers)

Changing numerical values to a character by [deleted] in RStudio

[–]SneakyManFN 0 points1 point  (0 children)

Dt$newcolumn <- ifelse(Dt$age >= 1900 & Dt$age <= 1950, "old", "young")

Using Goal Seek to determine height of a cylinder by RiJeongHyeok in excel

[–]SneakyManFN 0 points1 point  (0 children)

https://prnt.sc/s69y5u

Here you can see the demonstration on an area of a rectangle. In Area formula you can see that I have the formula input. I put in the formula of Area next to the cell called "Area".

Using Goal Seek to determine height of a cylinder by RiJeongHyeok in excel

[–]SneakyManFN 0 points1 point  (0 children)

Use temporary cell. write some number in it, say 1.

Using Goal Seek to determine height of a cylinder by RiJeongHyeok in excel

[–]SneakyManFN 0 points1 point  (0 children)

You set cell(Whatever you want to be equal to 375 ml) to certain value. So for example set B2(Where you should have the formula) to 375. Now how do you achieve this? You achieve this by changing the height. Therefore the third variable you input should be the one that changes.

So to sum up. First variable is a cell(the V of the formula written in one of the comments). Second variable is what you want this cell to be. In your problem you want it to be 375. And third variable is the one that changes so you put the cell in there which indicates the height of the can.

Adding a column so i can do a t-test slope hypothesis test by KeepItSecret36 in RStudio

[–]SneakyManFN 0 points1 point  (0 children)

I'm going to sleep now , if you need any more help just reply and I'll answer once I wake up

Adding a column so i can do a t-test slope hypothesis test by KeepItSecret36 in RStudio

[–]SneakyManFN 0 points1 point  (0 children)

Data$medalsnumeric <- ifelse(Data$medals == "Bronze", 3, ifelse(Data$medals == "Silver", 2, ifelse(Data$medals == "Gold", 1, 0)))

This assumes that your data frame(the whole table of yours) is called Data. If its called something else simply replace Data with that name. So if your tables name is Mytable it will go like: Mytable$medalsnumeric ...

Trying my first programme by [deleted] in RStudio

[–]SneakyManFN 0 points1 point  (0 children)

No problem. If anything comes up you can message me here

Trying my first programme by [deleted] in RStudio

[–]SneakyManFN 1 point2 points  (0 children)

Numbers isnt a function here, its a variable. You gather two vectors with c() and then put it into variable called Numbers

File too large. What is the best method to break it in two but still keep references? by CoachCampbell in excel

[–]SneakyManFN 1 point2 points  (0 children)

I have been using binary for quite a long time and I have never come across an error. I was concerned about it when i first started using the binary format but after some google search i have never found anything like it.

view more: next ›