Advertisements this is a sample diabetics dataset I want to get only the 2 mentioned columns as the output but i am not sure about the code for that df.get("gender", "heart_disease") I tried this and the code is working but I am only getting the output of gender want only 10 sample outputs. how do… Read More abstracting 2 columns from a dataset with a specific sample of 10
Advertisements To simplify this problem I’ll use a very basic subset of what the dataset might look like: library(dplyr) DF <- tibble(id = seq(1:4), label = c("A", "B", "C", "D"), val = c(NA, "5, 10", "20", "6, 7, 8")) DF # A tibble: 4 × 3 # id label val # <int> <chr> <chr> #… Read More How to duplicate specific rows but changing the value in one column by splitting by the comma separated values of an original cell in R
Advertisements I was wondering how i could ‘translate’ the values of one data set to another. Here is what I mean: I have a data set of values that I would like to translate to midi pitches. This specific instrument in midi has a range of 33 through 128. I would like to translate values… Read More Translating the values of one data set to another
Advertisements I’m working with a dataset about weather where one row contains amount of rain in mm. Problem is it hasn’t been recorded in the same format, so while some rows contain just numbers, some contain numbers and "mm". It look something like below: Date Rain 1 2014-12-08 10mm 2 2014-12-09 3 3 2014-12-10 5mm… Read More How do I change values from xx mm to just xx in R?
Advertisements I have a dataset given as such: #Load the required libraries import pandas as pd #Create dataset data = {‘team’: [‘A’, ‘A’, ‘A’, ‘A’, ‘A’, ‘A’, ‘A’, ‘A’, ‘A’, ‘A’, ‘A’, ‘A’], ‘Run_time’: [1, 2, 3, 4, 5, 1, 2, 3, 1, 2, 3, 4], ‘Married’: [‘No’, ‘Yes’, ‘Yes’, ‘Yes’, ‘No’, ‘Yes’, ‘Yes’, ‘Yes’,… Read More Modify a column in Python such that the numbering is continuous
Advertisements I’m new with python and pandas and I’m struggling with a problem Here is a dataset data = {‘col1’: [‘a’,’b’,’a’,’c’], ‘col2′: [None,None,’a’,None], ‘col3′: [None,’a’,None,’b’], ‘col4’: [‘a’,None,’b’,None], ‘col5’: [‘b’,’c’,’c’,None]} df = pd.DataFrame(data) I need to create 3 columns based on the unique values of col1 to col4 and whenever the col1 or col2 or col3… Read More Create a column based on a value from another columns values on pandas
Advertisements I have added a new column to my DataSet and after adding, visual studio asked me if I want to rewrite my updating methods and I said yes. Now, My Delete method is broken and I can not use it like before. What should I do ? >Solution : Amirhesam You have to manually… Read More How to rewrite the Delete and Update methods based on new DataSet binding?
Advertisements I have a train dataset with 4,000 examples, I want to split it randomly into 2 equal sub-datasets with 2,000 in each of them. As suggested here i used the split and drop methods like so: I1 = train_df.sample(frac=0.5, random_state=opts.seed) I2 = train_df.drop(index=I1.index) However it seems like it drops more indices for no apparent… Read More Dataset splitting with pandas sample and drop does not work as expected
Advertisements Hi I have a dataset that I have transformed to only nums and factors, I want to separate the factors columns from the numerical columns. I’m new to coding and its probably very simple but I’ve looked around and I’m very thankful if anyone could help ‘data.frame’: 400 obs. of 25 variables: $ age… Read More Sort dataset columns by num, then factors
Advertisements I have a data frame whose dimensions are (356027, 163). I want to create a dictionary from the data frame where i will have 163 keys with values which are the number of entries in them(i.e. number of non null entries) I tried using the to_dict() operation but couldn’t insert the values as the… Read More how to create a dictionary from a dataframe where the keys are column names and values are the number of values under each column?