Find Jobs
Hire Freelancers

Clean & reorganise R dataframe ~1hour job

€8-30 EUR

Closed
Posted about 7 years ago

€8-30 EUR

Paid on delivery
I have a 2706-row dataframe of measurements with Dates in one column and 41 different identifiers in other column. Dates are all different, but should be brought up to a single quarterly format: 200X-03-31 ,200X-06-30, 200X-09-30, 200X-12-31, where years change, but dates of the end of quarter always stay the same: 03-31 06-30,09-30, 12-31. To allocate the right measurements to the right end-of-quarter dates one just must remember that the reporting date is always after the date, to which the measurement corresponds to. For example, if a reporting date is 2017-02-17, it must be a value for Quarter 4 of 2016, that is - 2016-12-31. If the reporting date is 2013-05-08, then it must correspond to a previous quarter - that is Q1 2013, or in a date format: 2013-03-31. By assigning the right dates, it will be possible to aggregate the dataftame into a new format consistent for all identifiers. The values are all quarterly, but for 2 identifiers only annual numbers are available. To arrive at quarterly values for those 2 identifiers, simply divide the annual value by 4. The final deliverable must be the R script that performs the task described above. The script should be general enough to run it on other similarly structured input files. Please provide a bid first: requested budget for the entire project + delivery time. I shall then review the bids and choose a freelancer for this task. Thank you for your interest!
Project ID: 13336147

About the project

17 proposals
Remote project
Active 7 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
17 freelancers are bidding on average €29 EUR for this job
User Avatar
I have a good hand on working with Advanced Excel, R and Python. I have quite a good knowledge of Machine Learning Algorithm for Regression, Classification and Clustering. I have also developed dashboards and Shiny Web Application in R. The apps that I have built are highly interactive and informative. I understand the project requirement and will deliver the desired product within the time specified.
€25 EUR in 1 day
4.8 (75 reviews)
7.1
7.1
User Avatar
Hi, This is Santhosh from India. I am a Business Management Graduate with Computer Science engineering background who is passionate about Data, Mathematics and Technology. I have worked in many data analytics projects involving SAS & R. Also I have worked in projects involving Excel (Pivot Table, Macros) and VBA. I believe I have enough expertise in R to complete this project as per your requirement. I am sure that you will be 100% satisfied with my work. Please get in touch. Looking forward to hear from you. Thanks & Regards, Santhosh Kanna
€34 EUR in 1 day
5.0 (62 reviews)
6.0
6.0
User Avatar
I will pursue PhD in applied mathematics in the next academic session.I graduated from Indian Institute of Technology, Kharagpur in 2016. I have experience of implementing Factor Analysis, Principle Components analysis, multivariate regression , ANOVA , Regularized regression methods like LASSO and Elastic net, classification and regresison trees, Monte Carlo methods etc. in R. I have attached a few of my codes on my profile. I have had the opportunity of working as a research assistant at IIM Lucknow, where I looked into a data set pertaining to market advertisements , and I gained some experience in statistical learning. I ,also, worked in Nomura as an investment banking intern in the equity derivatives team. I have had the exposure to financial derivatives and have worked on momentum based strategies. I had taken up another project at IIT Kharagpur , which was pertaining to statistical learning , especially localized regularization. I have the experience of working on Excel VBA and R. I have sound knowledge of Linear Algebra, Mathematical analysis and probability theory. I am, currently, exposing myself to machine learning and a study of the theory of derivatives pricing.
€16 EUR in 1 day
4.9 (85 reviews)
5.9
5.9
User Avatar
I can perform the analysis using any kind of Statistical Software like R, SPSS , MINITAB Eviews Statistica etc I Will perform analysis like , Regression ,Time series ,Panel Data Experimental Designs Factor analysis , principle component analysis Bayesian analysis and other types of Data analysis Also i will provide Output and well explained interpretations with a comprehensive report
€50 EUR in 1 day
4.9 (80 reviews)
6.1
6.1
User Avatar
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (18+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply
€30 EUR in 1 day
4.8 (21 reviews)
5.7
5.7
User Avatar
Hi! It is hard to give precise estimate, however I can guarantee delivery of the results in 24 hours (most probably much faster). I would use dplyr package for this task.
€30 EUR in 1 day
5.0 (13 reviews)
4.8
4.8
User Avatar
Hello, Have a large experience working with R and different data. Would be happy to perform the work for you using such packages as lubtidate, zoo and anytime. Please contact me if the project is still available. Best regards Vova
€30 EUR in 3 days
4.9 (11 reviews)
4.3
4.3
User Avatar
I am a certified SAS and R professional I have strong analytical skills , quantitative and communication skills Have 5.6 years of industry experience in the field of supply chain 2 years of experience in Analytics
€23 EUR in 1 day
4.8 (2 reviews)
2.5
2.5
User Avatar
I am a R expert with experience in Classification and partitioning,Nureal Networks, Association rules. Also I am a Oracle Certified professional (OCP) with experience in Oracle,MySQL, SQL Server and MongoDB. I can help you with your requirements. Please initiate online chat.. so we can proceed with discussion
€35 EUR in 5 days
5.0 (3 reviews)
2.4
2.4
User Avatar
I am a statistician, and an R user so I can do the arrangements for you carefully. Hope I can help. Thank you!
€34 EUR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have already done something similar (except using the Q1 -> Q4 notation instead of dates). The code is ready to be adapted, will be commented and reusable. Nothing more to to say.
€19 EUR in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of GERMANY
Frankfurt, Germany
5.0
15
Payment method verified
Member since Mar 2, 2016

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.