Excel data transformations

I have an Excel file with 297868 rows of data, most with a 10-minute timestamp, and some collected hourly. I want to transform all the data to hourly, which means I need to average the data from the ten minute timestamps into an average over the hour, and convert the whole file to hourly. More specifically, there are two columns- one with the time/date (collected every ten minutes over ten years) and the second column has river height. I need the river height averaged over the hour and converted into an hourly average river height rather than every ten minutes. It would take me a long time but probably is fairly quick for someone more familiar with Excel. I need this done today.

Skills: Excel, Data Processing

See more: convert excel data md5 encryption form, convert data word excel data, convert excel data stata, convert excel data stata data, convert address list excel data, convert excel data small program, convert excel data word table, convert pdf excel data entry, convert pdf excel data entry job, convert excel data raw, convert excel data access database, convert excel data json object, convert excel data json python, convert excel data microsoft apple, convert excel data sql, excel data sorting work (quick pay!), excel data sorting work quick pay

About the Employer:
( 2 reviews ) MIll Valley, United States

Project ID: #20886425

27 freelancers are bidding on average $24 for this job


Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$30 USD in 1 day
(310 Reviews)

Please review my profile as i have relevant skills and experience required for this project. Kindly send me a message to discuss further. Thanks, Asad Khan

$30 USD in 1 day
(146 Reviews)

Hi There, Can you please send me the excel via Chat for better understanding on the file? Waiting for your response!

$25 USD in 3 days
(74 Reviews)

Hello, I am Luis and I can assist you today with this task. Please contact me by chat then we could discuss further details about your project. Kind regards, Luis Romero

$40 USD in 1 day
(118 Reviews)

I can definitely help you with that. I am a professional Data Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Excel, Power BI, Tableau and various other data analy More

$20 USD in 1 day
(51 Reviews)

Hello, How are you? I am very interested in your project. As you can see in my profile, I am freelancer to have 100% completed review. Especially I have rich experience in Excel and data management, several statistics More

$20 USD in 7 days
(3 Reviews)

Greetings, We have read the project description and understand the nature of the work. Experienced professionals, in web scrapping, data mining, lead generation and data compilation. Allow us to complete this project More

$20 USD in 2 days
(8 Reviews)

Hi there! it seems you need some calculation on your data (transform your data into hourly). I can help you. I have rich experience in excel (advanced formulas, VBA, Macro,....), and I do my best to save your time and More

$25 USD in 1 day
(29 Reviews)

I'm very interested in getting your work done. I feel confident to complete it according to your requirements because I have more than 3 years’ experience in compiling data in spreadsheet. I have gone through the proje More

$30 USD in 1 day
(4 Reviews)

Hi, I'm very much interested in this project. I have good experience in Excel data transformations. I ensure you, sir, I will provide you with better quality work than others. I'm able to send a sample please messa More

$25 USD in 1 day
(21 Reviews)

Hi, Greetings of the Day! Thanks for sharing your requirement and I will be more happy to assist you in this. Given a chance for an interview, I will be happy to discuss in detail about the requirement and assist you. More

$20 USD in 7 days
(4 Reviews)

Hi, i would like to take this opportunity to apply for the position. As a detailed oriented person i make sure any trusted projects will be posted or send accurately. I am always on time and is always prepared i make s More

$35 USD in 1 day
(1 Review)

Hello, i can convert your excel file due to requirements today, Regards, Alex.

$25 USD in 1 day
(2 Reviews)
$25 USD in 1 day
(0 Reviews)

Dear Hiring Manager At first taka my sincere respect.I have gone through your project [login to view URL] that i am able to understand that i have the enough skills to the [login to view URL] is some information about why More

$10 USD in 1 day
(0 Reviews)
$25 USD in 1 day
(0 Reviews)

Hi I have gone through the project description and very much interested in this project I am an experienced, hardworking and reliable virtual assistant Available now and ready to start the job right away click on t More

$30 USD in 3 days
(4 Reviews)

I like to do data entry work

$25 USD in 4 days
(0 Reviews)

Hi Dear Project Manager, i hope you are doing well.I just saw your request and interested to work with you. I will do data entry and i will make sure you will glad to see my work.I am having experience of more than 7 y More

$30 USD in 3 days
(0 Reviews)

I have a office based in India providing a one-stop solution for all your business needs, We provide a wide variety of services, such as Call center services, Virtual Assistants and Back office solutions. We have a More

$20 USD in 7 days
(0 Reviews)