data-manipulation
How to rotate excel data
This is a general question that just popped into my head that I have always wondered. There have been several times when I\'ve needed to rotate data in Excel, for example:[详细]
2023-02-09 07:03 分类:问答Vim search and replace, adding a constant
I know this is a long shot, but I have a huge text file and I need to add a given number开发者_运维问答 to other numbers matching some criteria.[详细]
2023-01-25 02:41 分类:问答Pythonistas, how do I move data from top to bottom to left to right in MySQL (think multiple values for each ID)?
Task at hand is to move data as shown in table 1 to that of table 2. Table (1) IDVal ----- 1a 1b 1c 2k 3l 3m 3n[详细]
2023-01-23 21:40 分类:问答Reshape error - invalid factor
I am somewhat new to R and I have run into a point where I need some help. I figure the reshape package can accomplish what I need to do.[详细]
2023-01-16 11:32 分类:问答Restructure Data in R
I am just starting to get beyond the basics in R and have come to a point where I need some help. I want to restructure some data.Here is what a sample dataframe may look like:[详细]
2023-01-11 02:28 分类:问答Most meaningful way to compare multiple time series
I need to write a program that performs arithmetic (+-*/) on multiples time series of different date range (mostly from 2007-2009) and frequency (weekly, mont开发者_如何学编程hly, yearly...).[详细]
2022-12-14 20:38 分类:问答What would the best technology/language choice be for converting MARK IV data manipulation programs?
My office relies on dozens of old MARK IV programs on a mainframe to pull down and manipulate data from a DB2 database into mainframe files (which eventually turn into excel spreadsheets at the moment[详细]
2022-12-09 22:57 分类:问答