Subsetting a data frame with R, by intervals of the data
I am trying to subset with R a big data frame (df). It has many columns and one of them is called Ratio_qubit_TS. I would like to subset it in a smaller dataframe (df_0.05) that only contains the values of Ratio_qubit_TS that are >= 0.5 and <1, with of course the other columns of my data frame that correspond to the selected rows. Then, I'll repeat this subsetting for different intervals of Ratio_qubit_TS.
I have tried to create a first subset of my data (=df_0.5), using this code, but I don't understand why it doesn't work : df_0.5 <- df[df$Ratio_qubit_TS >=0.5 & df$Ratio_qubit_TS <= 1]
The error message says :
Error in [.data.frame(df, df$Ratio_qubit_TS >= "0.5" & df$Ratio_qubit_TS <= :
undefined columns selected
If you had any advice on how I could solve that problem, it would be wonderful. It has been hours that I'm trying to find a solution and could not find any. And I you had an idea on how to make R repeat the process of subsetting my data frame for different intervals of Ratio_qubit_TS (ex : 1<=Ratio_qubit_TS<1.5, then 1.5<=Ratio_qubit_TS<2...etc), I would be so so grateful.
Thanks :)
PS : It's the first time that I post on this forum and besides English is not my mothertongue, so I hope that you will understand easily my problem.
Try this:
library(dplyr)
df_0.05 <- df %>% filter(between(Ratio_qubit_TS, 0.5, 1))
- How to add a hover-over tooltip to rhandonstable header cell?
- How to detect the right encoding for read.csv?
- Rcpp Rf_warningcall compiler warnings
- Modify the name of factor variables in lm function(summary function)
- Extreme value analysis and quantile estimation using log Pearson type 3 (Pearson III) distribution - R vs Python
- How to hide NAs when using xlsx::saveWorkbook?
- How do I retrieve a simple numeric value from a named numeric vector in R?
- Adding an image in navbar and adjusting alignment in Rmarkdown
- Matching pair-wise columns from left to right across rows in one dataframe to another dataframe and adding new columns with matching values
- Income to outcome flow chart in Sankey plotly R
- color mapping in geom_conn_bundle not showing correctly
- Print R package startup message AFTER automatic package conflict messages instead of before
- Summing a set of R dataframe rows (column-wise), while retaining the first n columns
- Added variable / partial regression plots for groups in an interaction?
- how to make a topoplot in R with coordinates variable distribution
- List of all functions in base R?
- Plotting multiple plots for different initial conditions in one graph
- Printing repetitively on the same line in R
- Generating UI/Server based on initial selection
- Subset dataframe based on pickerInput
- How to let user pick the data in R-shiny?
- Couldn't show my simple bar charts separately on Shiny R dashboardBody
- How to programmatically filter contents of a second shiny app displayed via iframe
- How to select specific interesting groups for the boxplot in R Shiny app?
- Crosstable and Plot grouping with reactive values
- Is there a way to make multiple Shiny picker inputs where the selections must be disjoint?
- Delay/avoid duplication of shiny server side functions until after credentials
- Predictions only returns value "1"
- How to display a busy indicator in a shiny app?
- Append doesn't work when writing to CSV in R