Data gurus, I need your help - Page 2 - Fuelly Forums

Android Users - Coming Soon! - Migrating from aCar 4.8 to 5.0

Reply
 
Thread Tools Display Modes
 
Old 02-27-2006, 05:48 AM   #11
Moderator
 
GasSavers_DaX's Avatar
 
Join Date: Oct 2005
Posts: 1,209
Country: United States
Re: the 97 file isn't TOO bad.

Quote:
Originally Posted by Matt Timion
What do you all think?
It's ok Matt...you can say yall.

I think the users building the database would be easiest since it sounds like once again too much bureaucracy fouls things up.
__________________

GasSavers_DaX is offline   Reply With Quote
Old 02-27-2006, 08:46 AM   #12
Registered Member
 
MetroMPG's Avatar
 
Join Date: Dec 2005
Posts: 4,223
Country: United States
agreed. simpler to let the

agreed. simpler to let the users enter their own epa figures. selecting from a db would be slick, but it's a big job to set up.
__________________

MetroMPG is offline   Reply With Quote
Old 02-27-2006, 09:23 AM   #13
Driving on E
 
Matt Timion's Avatar
 
Join Date: Sep 2005
Posts: 3,110
Country: United States
Re: agreed. simpler to let the

Quote:
Originally Posted by MetroMPG
agreed. simpler to let the users enter their own epa figures. selecting from a db would be slick, but it's a big job to set up.
I'm still going back and forth on it. If I convert all of the "spaces" to another character (I used the + sign) I can very easily sort the data. With PHP I can probably set up a function to convert the data to a MySQL table in about 20 minutes. Assuming the data is consistent among the years (or similar) it shouldn't be too difficult. I'll think about it more today.
Matt Timion is offline   Reply With Quote
Old 02-27-2006, 12:26 PM   #14
Driving on E
 
Matt Timion's Avatar
 
Join Date: Sep 2005
Posts: 3,110
Country: United States
I just spend an hour or so

I just spend an hour or so coding a PHP function to load the data. I now have 1984-1997 into a MySQL table. I still need to format it a bit, but I have year, make, model, displacement, city mpg, highway mpg, total mpg, and any extra notes the EPA included to distinguish between the models.

Later tonight I'll work on 98-2006, which should be extremely easy.
Matt Timion is offline   Reply With Quote
Old 02-27-2006, 04:55 PM   #15
Driving on E
 
Matt Timion's Avatar
 
Join Date: Sep 2005
Posts: 3,110
Country: United States
I have data from 85-2006

I have data from 85-2006 loaded into the database. Now I need to clean it. There are almost 25000 entries between those years. I'm certain that there are a number of duplicates, so I'll be coding a few things to remove them as well.
Matt Timion is offline   Reply With Quote
Old 02-27-2006, 05:19 PM   #16
Registered Member
 
krousdb's Avatar
 
Join Date: Feb 2006
Posts: 1,480
Country: United States
Location: Raleigh, NC
Re: I have data from 85-2006

Quote:
Originally Posted by Matt Timion
I have data from 85-2006 loaded into the database. Now I need to clean it. There are almost 25000 entries between those years. I'm certain that there are a number of duplicates, so I'll be coding a few things to remove them as well.
Would it be possible to paste the whole thing into an excel spreadsheet? I would like to have it for reference.
__________________


krousdb is offline   Reply With Quote
Old 02-27-2006, 06:19 PM   #17
Driving on E
 
Matt Timion's Avatar
 
Join Date: Sep 2005
Posts: 3,110
Country: United States
Re: I have data from 85-2006

Quote:
Originally Posted by krousdb
Quote:
Originally Posted by Matt Timion
I have data from 85-2006 loaded into the database. Now I need to clean it. There are almost 25000 entries between those years. I'm certain that there are a number of duplicates, so I'll be coding a few things to remove them as well.
Would it be possible to paste the whole thing into an excel spreadsheet? I would like to have it for reference.
I'll make that for you as soon as it's all cleaned up.
__________________

Matt Timion is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Web site errors jeffreydj69 Fuelly Web Support and Community News 3 04-18-2013 02:21 AM
Multiple fillups per day - graph order Davek Fuelly Web Support and Community News 5 11-01-2010 01:19 AM
Still hoping for FB app/badge & iPhone app Icehawk Fuelly Web Support and Community News 3 10-15-2009 12:10 AM
Incorrect Milage Calcuatlion PatM Fuelly Web Support and Community News 4 07-17-2009 08:21 PM
Unburned Fuel rh77 General Maintenance and Repair 11 11-30-2005 09:01 PM

Powered by vBadvanced CMPS v3.2.3


All times are GMT -8. The time now is 12:03 PM.


Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.