python (12.9k questions)
javascript (9.2k questions)
reactjs (4.7k questions)
java (4.2k questions)
java (4.2k questions)
c# (3.5k questions)
c# (3.5k questions)
html (3.3k questions)
Efficient methods for determining the largest set of complete data in a large dataset
I have a large-ish dataset (say 10mil rows by 1500 columns). Each row represents an individual and each column represents a question. I would like to find the largest set of non-missing data (i.e., n ...
TeresaStat
Votes: 0
Answers: 0
Interpolate Multiseries Data In SQL
I have a system that stores the data only when they are changed. So, the dataset looks like below.
data_type_id
data_value
inserted_at
2
240
2022-01-19 17:20:52
1
30
2022-01-19 17:20:47
2
...
Taylan Yuksel
Votes: 0
Answers: 2
How to fill NaN values based on the top and bottom strings with highest frequency
I have a dataframe of string values with missing values in it. It needs to be populated/filled by the below conditions.
From the NaN value index , Check the last 3 rows and next 3 rows and replace th...

Tamil Selvan
Votes: 0
Answers: 1
Replace outliers with NA
I have found this function and I would like to adapt it to replace outliers with NA instead of removing the observation.
I have tried to add <-NA in this line data <- data[!outliers(data[[col]])...
JuanJMV
Votes: 0
Answers: 1