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)

Questions - data-cleaning

Importing dataset: decimals and grouping problem

I have to do an analysis of this dataset and I am already struggling with some coding! I have imported a column with the numbers from a given dataset created on a notepad, sample: Numbers 1930.38 5550...
test-img

lkasquilici

r

import

data-cleaning

readr

Votes: 0

Answers: 0

Find rows that are identical in one column but not another

There should be a fairly simple solution to this but it's giving me trouble. I have a DF similar to this: > df <- data.frame(name = c("george", "george", "george", ...
test-img

Bradley Allf

r

duplicates

unique

data-cleaning

Votes: 0

Answers: 2

Latest Answer

I think the easiest way will be to use dplyr::count twice, hence for your example: df %>% count(name, id) %>% count(name) The first count will give: name id n george 1 2 george ...
test-img

Shane Smith

Check if a column value is numeric in pandas dataframe

I have a dataset that I want to clean. The data set consists of 54 columns and 315 rows. For one of the columns, I want to find whether all the values in that column are numeric or not. I have done th...
test-img

sats

python

pandas

data-cleaning

Votes: 0

Answers: 2

Latest Answer

A for loop is not needed to achieve this. You can use the pd.to_numeric method and by setting errors to 'coerce', all non-numeric values will be replaced with NaN. df['LotArea'] = pd.to_numeric(df['Lo...
test-img

peru_45

Editing data encapsulated in flags from text file

I am currently cleaning data from text files. And the files contains transcriptions of speeches from daily conversations. Some of the files are multilingual, a few examples of a multilingual portion a...
test-img

Damian Tan

python

data-cleaning

Votes: 0

Answers: 1

Latest Answer

Yes, Pls try this content="around that area,<tamil>அம்மா:ammaa</tamil> would have cooked too" ft=' '.join([word for line in [item.strip() for item in content.replace('<',' &l...
test-img

Bhargav

Posts

Questions

Blogs

Jobs