Articles about data manipulation

Excel VBA: Splitting Dynamic Filename into Two Column Values + 1 Static Value

Learn how to split dynamic filenames into two column values and one static value in Excel VBA. This tutorial will help you streamline your data processing and meet project deadlines. Read more!

how to display values from column B in a list based on values in column A (CSV example)

This tech support article explains how to display values from column B in a list, where each value corresponds to a specific value from column A in a CSV file. The resulting list can be used for data analysis or reporting.

Splitting Full Names into First, Middle, and Last Names using Pandas - A Tech Support Guide

Learn how to split full names into first, middle, and last names using the Pandas library in Python. This guide is helpful for those who need to parse large datasets containing names and extract individual components. Make your data analysis more efficient and accurate by following this step-by-step tutorial. Read more to discover the power of Pandas for text processing and data manipulation.

Extracting Dates from Table: Single Column Sorting

Learn how to extract dates from a table with multiple dates per row and pull them into a single sortable column using VBA in Excel.

Splitting Delimited Strings Twice into a Two-Column Table: A Comprehensive Guide

Learn how to split delimited strings twice and convert them into a two-column table. This tutorial covers various techniques for different operating systems including Linux, Windows, and MacOS.

Delete Empty Rows: Columns Keep - Tech Support

Learn how to delete empty rows while keeping the columns in various data handling applications like Excel, LibreOffice Calc, and Google Sheets.

Mirroring and Flipping Excel Cell Timeduration Data

Learn how to mirror and flip the timeduration data in Excel cells for efficient data analysis. This tutorial covers copying and pasting hh:mm:ss formatted data.

Prevent Hidden Cells from Changing in Filtered Ranges: A Tech Support Guide

In this tech support article, we'll explain how to prevent hidden cells from changing in a filtered range. Follow these steps to maintain the integrity of your data.

Date Format Wrong Order: Fixing Thousands of Records

Learn how to correct date format issues in large databases using SQL queries and tools like MySQL and PostgreSQL.

Matching One Column Another: Power Plant Coordinates in Excel

Learn how to match one column against another in Excel using various methods, including VBA and Power Query, to merge data from different worksheets or tables based on common coordinates, states, or cities of power plants.

Breaking Single Column into Multiple Columns: Handling Grouped Rows in Excel

Learn how to break a single column into multiple columns when dealing with grouped rows in Excel. This technique is useful when you want to convert row data into column data, but the rows have an unequal number.

Date Extraction and Sorting from Pandas Series with Regex in Python

Learn how to extract and sort dates from a Pandas Series with different formats using regex in Python. This tutorial provides a step-by-step guide to handling the challenge of sorting dates in Pandas.

R-way compare individual item's column strings in data set

This article explains how to compare values of strings in a column across rows in a subset of a data set using R. Learn how to efficiently compare and identify differences in your data.

Combine Two Columns with Different Values in PySpark SQL - A Tech Support Guide

Learn how to combine two columns with different values in PySpark SQL. This guide provides a step-by-step tutorial on how to create a combined table using PySpark SQL. Follow along to enhance your data manipulation skills in PySpark.

Binding Rows of Two quanteda Corpora with Same Docvars

This article explains how to bind the rows of two quanteda corpora with same docvars in R. Learn how to combine and manipulate text data in R for text mining and analysis. Improve your data manipulation skills in R.

R gsub Issue: Unintended Word Removal with Column of Replacements

Learn how to troubleshoot R gsub function removing unintended words when using a column of replacements. Improve your text processing skills with this helpful tech support guide.

Interweaving Groups in Pandas: A Comprehensive Guide

Learn how to interweave groups in Pandas for efficient data manipulation and analysis. This tutorial covers the basics of the interweave function, how to use it, and its advantages. Improve your data analysis skills with this comprehensive guide.

Replace nan value in a pandas dataframe where column is string type

Learn how to replace NaN values in a pandas dataframe column that is of string type using Python 3.x and the pandas library. This article provides step-by-step instructions and code examples to help you efficiently handle missing data in your dataframes.