Everything2
Near Matches
Ignore Exact
Full Text
Everything2

massaging data

created by kto9

(idea) by kto9 (3.8 wk) (print)   ?   (I like it!) Mon Oct 15 2001 at 2:44:54

Massaging data is the act, sometimes art, of converting, correcting, or filtering a dataset in preparation for final processing. Data needs to be massaged when its original form doesn't lend itself to easy or correct analysis.

Every dataset has its own peculiarities. Programs used to scrutinize the data have their own idiosyncrasies. Conflicting date formats, illegal characters, duplicate data -- the list of possible problems is virtually infinite, especially if you have no control over the input to the dataset.

Sometimes solutions are simple. You may have a set of temperatures from major cities around the world, some in Fahrenheit, some in Centigrade. A simple math conversion and all your numbers are soon on the same scale and ready for comparison.

Or you may be given millions of names with addresses and some personal information, collected from various sources, and asked to provide the names and addresses of a specific subset; let's say all married couples where one or both spouses are over age 64. You'll quickly find that data from Source A has a name format of < firstname middle_initial lastname> , Source B uses < lastname firstname middle_initial> , and Source C lists just < firstname lastname> . Before you can even begin to try and extract the data you want, all the fields are going to have to be examined and their data massaged, so that you can make valid comparisons.

When the information being dealt with is fairly simple of itself, massaging the data may be time consuming, but shouldn't be very difficult. But when the data becomes more complex - say the results of a space-based spectral image processing system - identifying good and bad data is a job only for specialists in the particular field.


printable version
chaos

Salting Portuguese man-of-war Data Cult Until death do us part
Necked back rub filter conversion
data mining data processing massage American Anti-Slavery Society
massage ethics Python
Y'know, if you log in, you can write something here, or contact authors directly on the site. Create a New User if you don't already have an account.
  Epicenter
Login
Password

password reminder
register

Everything2 Help

Cool Staff Picks
Little presents from the Node Fairy:
Manifesto of Futurist Musicians
You are as dazzling as a pregnant cow attired in electrical sockets
Vicar or whatever
His Dark Materials
grunts
Carousel of Progress
It's time to take the penny out of circulation
Selection and care of kitchen knives
Elementary and Secondary Education Act
Don't touch me when I'm screaming
Rome
cyclic
What do I call her?
New Writeups
XWiz
Trism(review)
artman2003
Briefcase Full of Souls - Part I(fiction)
Dreamvirus
Alan Ladd(person)
waverider37
Harold Holt(person)
The Debutante
Until death do us part(fiction)
Ysardo
a brother to a sister(personal)
antigravpussy
your warm whispers(personal)
Clarke
Multiculturalism(idea)
aneurin
Earl of Landaff(person)
Heitah
Pseudocide(idea)
XWiz
Google Knol(lede)
Mythi
July 24, 2008(personal)
locke baron
The fall of Earth(fiction)
BookReader
Fear the Cold(dream)
Pavlovna
Kathleen MacInnes(person)
Everything 2 is brought to you by the letter C and The Everything Development Company