Clean and Standardize Plaintext Data

Færdiggjort Opslået Oct 21, 2008 Betalt ved levering
Færdiggjort Betalt ved levering

The US Department of Energy publishes the fuel efficiency (i.e. MPG) of all vehicles sold in the US each year. These statistics are available from 1978-2009 at [url removed, login to view] We need to import these statistics into an application we've built. However, the files are not all formatted consistently. We are looking for someone (or a team) to go through the data for each year 1978-2009 and reformat the data in a consistent format.

## Deliverables

The deliverables are a set of CSV files, one for each year from 1978 to 2009, inclusive. (i.e. we expect 31 CSV files). Each year's data should be saved as a CSV file with the filename [year].csv. So, for example, the 2004 data should be saved in 2004.csv. Each CSV file should contain the following columns: - YEAR - MAKE - MODEL - TRANS_TYPE - DISPLACEMENT - CYLINDER_COUNT - FUEL_TYPE - CITY_MPG - HIGHWAY_MPG - COMBINED_MPG Valid values for TRANS_TYPE are: - 'A' (automatic) - 'M' (manual) Valid values for FUEL_TYPE are: - 'R' (regular petrol) - 'P' (premium petrol) - 'D' (diesel) - 'E' (E85 Ethanol) - 'C' (compressed natural gas) The TRANS_TYPE, DISPLACEMENT, and CYLINDER_COUNT fields are optional. I recognize that some of the older data files won't have these fields. When a data file doesn't specify a fuel type, you should assume that it is an 'R'. I went ahead and converted the 2009 data to this format to give you an example of what I'm looking for. That file is attached.

## Platform

n/a

Dataindførsel

Projekt ID: #3329225

Om projektet

11 bud Remote projekt Aktiv Oct 22, 2008

Tildelt til:

iasmumbai

See private message.

$85 USD in 4 dage
(118 bedømmelser)
5.5

11 freelancere byder i gennemsnit $141 timen for dette job

vw6891883vw

See private message.

$169.22 USD in 4 dage
(1 bedømmelse)
0.9
vw7029195vw

See private message.

$170 USD in 4 dage
(1 bedømmelse)
0.2
inphaser

See private message.

$85 USD in 4 dage
(1 bedømmelse)
0.0
Apogeesolutions

See private message.

$85 USD in 4 dage
(1 bedømmelse)
0.0
kanrenv

See private message.

$85 USD in 4 dage
(0 bedømmelser)
0.0
onestyle

See private message.

$446.25 USD in 4 dage
(1 bedømmelse)
0.0
Chetan2075

See private message.

$85 USD in 4 dage
(0 bedømmelser)
0.0
pgmexpert

See private message.

$85 USD in 4 dage
(0 bedømmelser)
0.0
lllaatishlll

See private message.

$170 USD in 4 dage
(0 bedømmelser)
0.0
bljrun

See private message.

$85 USD in 4 dage
(0 bedømmelser)
0.0