python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - data-cleaning

Using a key to clean data in two corresponding columns

I have a large data frame (6 million rows, 20 columns) where data in one column corresponds to data in another column. I created a key that I now want to use to fix rows that have the wrong value. As ...
test-img

Nani Ve

r

dataframe

data-cleaning

Votes: 0

Answers: 2

Latest Answer

Using dplyr. If you want to fix sound according to animal, library(dplyr) df <- df %>% mutate(sound = sapply(animal, function(x){key %>% filter(animal==x) %>% pull(sound)})) should do ...
test-img

Valkyr

In Python, run each row in a csv through tests and output a new csv showing which test each row failed

In python, I would like to run a csv through test cases checking for data anomalies while keep track of each test it fails. This is my first big project in Python, though I have Python experience and ...
test-img

feelsgood

python

pandas

csv

data-cleaning

pseudocode

Votes: 0

Answers: 1

Latest Answer

import pandas as pd import numpy as np data = pd.read_csv(csv_file, encoding='latin-1') # Create array to track failed cases. data['Failed Test']= '' data = data.replace(np.nan,'') data.ins...
test-img

feelsgood

UnRAR DLL unable to be referenced in C#

I was trying to make a program to clean out some directories on my NAS and I noticed that a lot of folders contained nested rar and zip files and I have plenty of space to unpack them. The program sh...
test-img

Apolloin

c#

visual-studio

data-cleaning

unrar

Votes: 0

Answers: 1

Latest Answer

SO I was able to get it working with the source code from the great people over at SharpCompress and utilizing their source I've got the following stable build. using SharpCompress.Archives; using...
test-img

Apolloin

i want to find the negative and positive of the same value in column and delete it

I have a data of transaction and there's refunds in it and i want to select it and delete it, you can say my data look like this : product key mtligne_ttc partner_id date 1001 ...
test-img

kourdassi mohammed abderrezak

python

data-science

data-cleaning

Votes: 0

Answers: 1

Latest Answer

I spent 2 hours looking to the problem and when i gave up i tried to post here but the funny thing 22 min later i solved it. My solution was there's was the quantity columns in the dataset. and if som...
test-img

kourdassi mohammed abderrezak

Posts

Questions

Blogs

Jobs