Search code examples
ReplaceValue not working in Excel Query Editor...


excelpowerbipowerquerydata-cleaningm

Read More
Excel Power Query Conditional Replace Based on Another Column...


excelpowerbipowerquerydata-cleaningm

Read More
How to tally occurrences of a value in a column in R?...


rdplyrtidyversedata-cleaningdata-wrangling

Read More
How to make a keyword you look for return true when using it in text strings?...


pythonpandasdata-cleaning

Read More
Referencing a function argument as a column name in pivot_longer...


rfunctionconcatenationtidyrdata-cleaning

Read More
Removing Specific Lines in Json File...


pythonjsondata-cleaning

Read More
how to get rid of ".0" in python...


pythonpandasdata-cleaning

Read More
Cleaning dataset based on a reference file...


rdata-cleaning

Read More
Strip strings and date, time from mixed string with numbers...


pythonarrayspandasdata-cleaning

Read More
How to clean csv data over multiple columns?...


pandasmultiple-columnsdata-cleaning

Read More
Is there an R function to select specific row numbers?...


rtidyrdata-cleaning

Read More
How to trim X% top and bottom of a data frame (based on a column)?...


rsortingdata-cleaningtrim

Read More
Error filtering multiple csv files based on rows...


pythondata-cleaningkeyerror

Read More
R: length of vector not equal to column numbers...


rdata-cleaning

Read More
What gets passed to the mutate and modify?...


rif-statementdata-cleaningpurrrmutate

Read More
Error when trying to create a list of files...


pythonoperating-systemtypeerrordata-cleaning

Read More
To regularize every incidence of the term 'Heb' to "HEB" in pandas df...


data-cleaningregex-group

Read More
Is there an easy way to get the transpose of a data frame while grouping the values of one of their ...


rdataframedata-cleaningtransposereformatting

Read More
How to get the matched groups in regex Python and save it as a new column...


pythonpandasregexdata-cleaningstring-matching

Read More
R: Transpose Data from Wide to Long in Dataframe with many column names...


rdata-cleaningtranspose

Read More
Accumulate strings between years using midpoint assumption...


rdataframedplyrdata.tabledata-cleaning

Read More
Remove dot inside a number...


jsonvimdata-cleaning

Read More
How to solve error related to name repair startegy with double pivot_longer...


rdataframedplyrpivotdata-cleaning

Read More
How to combine row and column name of df when value in target cell of df is not NA...


rdataframefilterdatasetdata-cleaning

Read More
Delete all remaining observations from data frame when exceeding a specific value...


rdataframefilterconditional-statementsdata-cleaning

Read More
Compare two columns and replace the value in column 2 with NA if same as column 1...


rdataframedplyrconditional-statementsdata-cleaning

Read More
Finding common columns in two dataframes and retaining only those columns that are common between th...


rdataframedplyrdata-cleaning

Read More
function for reshaping data efficiently...


rdataframepivotreshapedata-cleaning

Read More
How to merge two datasets in R by partially matching text in columns?...


rdataframejoindplyrdata-cleaning

Read More
Extract number within brackets at the end of a string - (YYYY)...


rdataframedplyrdatasetdata-cleaning

Read More
BackNext