Find Jobs
Hire Freelancers

CSV Manipulation, use Regex or TSQL maybe

$30-250 AUD

Closed
Posted almost 10 years ago

$30-250 AUD

Paid on delivery
Hi Developer, We urgently have a requirement to manipulate some data in a CSV / Excel file. The data is currently displays power readings for every minute of a day. We need to DELETE most of this data and only keep data for every hour. Also the date is currently in a row on its own: eg. (Tuesday, 10th December, 2013) we need this to appear in a column beside the time OR in the same column as a DATETIME Have a look at the data nad let me know.
Project ID: 5750550

About the project

46 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
46 freelancers are bidding on average $122 AUD for this job
User Avatar
Dear Stephen I had a look at the excel sheet. I have a few questions. Do you need to delete the old data from the database or in the CSV file? Where does this csv stored? Is it to a remote directory or where? Who creates this csv etc. Thanks Ri
$154 AUD in 3 days
4.9 (491 reviews)
8.0
8.0
User Avatar
Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.
$80 AUD in 0 day
4.9 (322 reviews)
7.6
7.6
User Avatar
Hi, I am an Excel macro expert and would be happy to assist you in this project. Shall provide you with an Excel automated tool, which will prompt the user for selection of csv file and automatically generate the output file with hourly readings and date in place. Let me know. Regards, Arul
$100 AUD in 1 day
5.0 (284 reviews)
7.3
7.3
User Avatar
Hello Sir, I will create a Windows application for you to parse the CSV & save in a database. Ready to start. Thanks, Alex
$195 AUD in 3 days
5.0 (158 reviews)
6.9
6.9
User Avatar
Dear, Really simple task, I can do it right know. I already check your xls file. Please let me know. Regards, Fabrice
$67 AUD in 1 day
4.7 (83 reviews)
7.2
7.2
User Avatar
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive response. Thanks.
$150 AUD in 5 days
4.9 (138 reviews)
6.3
6.3
User Avatar
Hi, I am interested in your project. You can count on me for a fast and 100% accurate job done. First of all I noticed that there are some minutes of the hour missing (like 12:15:43, and mores). But this is not a problem at all, just letting you know. Also, you say you want the data per hour. What would be the row (minute) we will keep for each hour? First, last or somewhere in the middle? Or maybe an average or all minutes? Also I will add new column for date. Thanks and looking forward to hearing from you, Peter
$70 AUD in 2 days
5.0 (50 reviews)
6.0
6.0
User Avatar
I can give you a simple script to be executed in Windows, that processes the input file and produces an output file in csv format as well, with one header line, one row per each hour and the additional head column with the date in it. If you want the script can also directly write to a database of yours, instead of producing a csv file. Or it might even produce a .xlsx file I need to know: 1. do you want the date to be formatted in ISO (yyyy-mm-dd) or in other format? 2. what row is chosen for each hour (first one, middle one, last one, one with average/min/max value in some column)?
$80 AUD in 1 day
5.0 (31 reviews)
6.1
6.1
User Avatar
I can write a script to leave only data for every hour and also move the DATE from its own row to TIME column (or in its own column if you wish).
$55 AUD in 3 days
5.0 (58 reviews)
6.1
6.1
User Avatar
Hi, I had created your project "Simple WinForms GUI needed (screens only) - ECNTelephony". Your project suits my expertise very well. Lets discuss further through inbox/messages. About me : I having 10 years of Software development experience in .NET, C#, VB.NET, SQL Server, MySQL, SQLITE & completed 63 projects in Freelancer.com in last 2 years, all the clients are satisfied & given me 5 on 5 marks in every category, you can read the reviews in my profile. www.freelancer.com/u/skctechno.html
$244 AUD in 5 days
5.0 (13 reviews)
5.6
5.6
User Avatar
HI, This can be achieved by designing a C# win-Forms application. Application will read this CSV file and import data in SQL Server. I have 9 years experience in C#, Win-Forms, ASP.NET/ MVC with Jquery/Ajax and for services using WCF/Rest WCF/Rest Web ApI and SQL Server 2008/R2/2012 for back-end. I have delivered highly successful projects in ASP.NET, C# Win-Forms with complex logic in SQL Server Stored Procedures. Thanks
$244 AUD in 15 days
4.7 (29 reviews)
6.1
6.1
User Avatar
Hi, I can develop a simple windows form application for you which will take the excel file as input and give u output excel file with the data manipulation as u mentioned in your project description. For any question or concern you are warmly welcome. Thanks
$50 AUD in 1 day
4.9 (35 reviews)
5.7
5.7
User Avatar
Hello stephenrob , I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases, i have more than 8 years in IT projects with 5 years working around Microsoft Excel database and VBA on several projects . My last job was database consultant within Accenture ,for more than 4 years .I worked for several projects relating with Microsoft databases on behalf of European Customers (Carrefour, LOREAL,Eurovia ..). I have strong skills in MS Excel and VBA to develop all types of requirements related ,and given my experience, I think I have all the skills to give High quality of work delivery withing budget and time Best regards,
$54 AUD in 1 day
4.9 (22 reviews)
5.4
5.4
User Avatar
You got it. I can fix it tonight. Is this the file that needs to be changed or you have some other file to work on? Awaiting your response.
$210 AUD in 0 day
5.0 (11 reviews)
5.0
5.0
User Avatar
Aucune proposition n'a encore été fournie.
$147 AUD in 3 days
4.3 (44 reviews)
5.6
5.6
User Avatar
Hi, I could do this for you using RegularExpression or\and T-SQL by importing data into one of the database system (PSQL, MS SQL, SQLite etc). Thanks, Andriy
$35 AUD in 2 days
5.0 (38 reviews)
5.0
5.0
User Avatar
Hello sir, I am interested in your project and offer my services. Do you need sum of all numeric fields of each hour ? Or average etc... Please contact for further details. Looking Forward Nblsoft
$77 AUD in 1 day
5.0 (7 reviews)
4.5
4.5
User Avatar
Hi, I understood it perfectly. Please see my anylysis below: Report contains data of 100 Days First date in report is Tuesday, 10th December, 2013 Last date in report is Thursday, 20th March, 2014 Below is sample records for first day and 3 records from next day. Tuesday, 10th December, 2013 Time,voltage,current,apparentpower,frequency,mainenergy,powerfactor,activepower 12:10:42,237.62,0,0.56,50.02,13.441,100,0.56 13:00:45,236.39,0,0.95,50.02,13.486,100,0.95 14:00:49,236.85,0,0.66,50.02,13.487,100,0.66 15:00:54,237.4,0,0.69,50.02,13.488,100,0.69 16:00:57,238.19,0,0.46,50.02,13.488,100,0.46 17:05:59,239,0,0.76,50.11,13.489,100,0.76 18:00:02,238.03,3.47,825.96,50.02,14.029,92,762.1 19:00:51,241.72,3.43,829.1,50.02,14.802,92,762.1 20:11:55,242.01,3.42,827.67,50.02,15.705,92,763 21:00:57,245.24,3.39,831.13,50.02,16.328,92,763.09 22:00:00,242.91,3.4,827.32,50.02,17.076,92,761.31 23:00:02,247.72,3.36,832.34,50.11,17.84,92,764.07 Wednesday, 11th December, 2013 00:00:07,246.11,3.37,831.34,50.02,18.6,92,763.39 01:00:10,241.32,3.4,820.49,50.02,19.364,92,758.46 02:00:13,242.29,3.39,821.36,50.02,20.121,92,757.17 03:00:18,243.66,3.38,823.57,50.02,20.881,92,759.25 For better view, please copy above data and past in CSV file. Please let me know if you want to sample records in CSV format. On provided opportunity to working with you, I am able to deliver this file within 24 hours after assigning this project to me. I look forward for your approval soon. Thanks, Ashok
$40 AUD in 1 day
5.0 (25 reviews)
4.3
4.3
User Avatar
Hi Stephenrob, I work in data analytics and manipulate data of this kind quite regularly. I have seen the data and can definitely do what you are after. My plan is to import into a SQL database and use TSQL to manipulate the data to extract what you are after. I can have this done before COB (Syd time) if you assign to me today. Cheers Mav-Team
$150 AUD in 2 days
4.9 (8 reviews)
4.1
4.1
User Avatar
Hi, I can do small program to separate your data file to files for each date. Thank you, Salvi.
$155 AUD in 5 days
5.0 (1 review)
3.8
3.8

About the client

Flag of AUSTRALIA
Brisbane, Australia
5.0
4
Payment method verified
Member since Aug 20, 2011

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.