data-manipulation

Removing elements with Array.map in JavaScript

I would like to filter an array of items by using the map() function. Here is a code snippet: var filteredItems = items.map(function(item) { if( ...some condition... ) { return item; } }); The problem is that filtered out items still uses space in the array and I would like to completely wipe them out. Any idea? ...

How do I remove objects from an Array in java?

Given an Array of n Objects, let's say is an Array of Strings, and it has the following values: foo[0]="a"; foo[1]="cc"; foo[2]="a"; foo[3]="dd"; What do I have to do to delete/remove all the Strings/Objects equal to "a" in the Array? Thanks! ...

How do you handle the fetchxml result data?

I have avoided working with fetchxml as I have been unsure the best way to handle the result data after calling crmService.Fetch(fetchXml). In a couple of situations, I have used an XDocument with LINQ to retrieve the data from this data structure, such as: XDocument resultset = XDocument.Parse(_service.Fetch(fetchXml)); if (resultset.R...

Artificially Add a Record To MySQL Results

Is there any way to slip in a record to the top of a result set in MySQL? For instance, if my results are: 1 | a 2 | b 3 | c etc I want to be able to get: Select | Select 1 | a 2 | b 3 | c etc Where "Select" isn't actually a part of the recordset, but artificially inserted. Thanks. ...

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). I have been tasked with starting the conversion process - understanding these programs and moving the logic over to a modern technology...

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, monthly, yearly...). I came up with - find the series with the highest freq. then fill in the other series with zeros so they have the same number of elements. then perform the operati...

Restructure Data in R

Hi Everyone, 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: ID Sex Res Contact 1 M MA ABR 1 M MA CON 1 M MA WWF 2 F FL WIT 2 F FL CON 3 X GA XYZ I want the data to look lik...

Reshape error - invalid factor

Hi All, 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. Here is the structure of the original data frame: > str(bruins) 'data.frame': 10 obs. of 6 variables: $ gameid : Factor w/ 1 level "20090049": 1 1 1 1 1 1 1 1 1 1 $ team : chr "NYI...

What programs or techniques do you use for reading/manipulating files with fixed length records?

When mocking up test data for our product, or debugging customer data, it would be nice to have an app that is able to highlight columns or groups of columns as fields, or even to have the editor be aware of which columns are grouped together into fields. Currently using Vim, which is the best I've come across so far for this task. I'm...