Find Jobs
Hire Freelancers

Program for Data shifting in .csv excel file

₹600-1500 INR

已完成
已发布超过 5 年前

₹600-1500 INR

货到付款
I have uploaded here a .csv excel file in which a program needs to be developed. It contains approximately 17 series of data e.g. column A to G represents 1st series, column I to T represents 2nd series and so on. There is a(one) column gap between each series. First series A to G and last series GW to HC need not be done anything. Programming is required for second series to 16th series of data. Each series contains a column heading TIME. Time generally starts from 9:16:00 for each series. But for some series time starts from different time e.g. for this source file, 2nd series time starts 9:16:00, 3rd series 9:18:00, 5th series 9:33:00 and so on. There is no guarantee of the extent of (Time) deviation for different series. When a new data is entered different series may have different extent of deviation. A program needs to be developed to produce the result file, in which all data in the deviated series will be shifted downward equal to the extent of deviation. e.g. if deviation is by 1 minute, then it will be shifted by 1 column, if deviation is by 8 minutes then needs to be shifted in by 8 column...... equal to as shown in result file. For 16th series many times there comes an extra row 9:15:00, which needs to be deleted (if present) and shift the whole data in that series upward, as shown in result file. Data is reentered into the source file regularly, erasing the previous data. Once data is reentered the program will check the each series again and shift data accordingly. If there is a shift in the series, the excel file usually asks to save the file before entering new file, as shown in the image file(uploaded). The program needs to be made, so that it automatically discard changes in (or never asks to save the change in) the excel file, which is made by the program. Otherwise new data cannot be reentered into the source file.
项目 ID: 18460381

关于此项目

7提案
远程项目
活跃5 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
Hello, sir i am interested in this project , i can begin now waiting your answer on chat Regards
₹1,375 INR 在0天之内
4.9 (42条评论)
4.5
4.5
7威客以平均价₹1,275 INR来参与此工作竞价
用户头像
Hello, I am Excel and VBA expert. I understand the requirements and I can do it today If you have any questions, I will be happy to answer. Please note that I have 100% completion rate and 5-star feedback on over 50 projects. Jan
₹1,500 INR 在0天之内
5.0 (78条评论)
5.8
5.8
用户头像
yes buddy, me here to start, u will feel brotherhood,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
₹650 INR 在1天之内
4.4 (10条评论)
2.3
2.3
用户头像
Hello, I'm experienced java developer and had a lot of work with data processing. I think I can complete that project in few hours. Program will check specified file every N time to ensure it was changed and then apply calculations (shifting etc). So file will not be locked at all. No additional soft required (like Excel). But there are some things I didn't fully understand about excel file saving, like if csv file will be opened / edited in excel? Feel free to contact me so we can discuss all the details to be sure job will be done exactly for your needs. Thanks.
₹1,150 INR 在1天之内
5.0 (3条评论)
1.5
1.5
用户头像
Hello? I am a Data scientist with over 5 years experience in using python and excel for data mining, cleaning analysis, visualization and modeling. I can provide intuitive python or g-script (excel functions/formatting)codes. I look forward to your response.
₹1,500 INR 在1天之内
5.0 (1条评论)
0.5
0.5
用户头像
I have 9 yrs of experience in data mining. Please give me a chance to work. I am a quick learner.
₹1,250 INR 在3天之内
0.0 (0条评论)
0.0
0.0

关于客户

INDIA的国旗
JUNAGARH, India
5.0
4
付款方式已验证
会员自2月 6, 2014起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。