Find Jobs
Hire Freelancers

r code - left join or merge between data frames based on 2 criteria: numerical match and date range evaluation

$30-250 CAD

Suoritettu
Julkaistu 7 kuukautta sitten

$30-250 CAD

Maksettu toimituksen yhteydessä
I have two data frames: summary and hauled (complete df’s attached to posting). I want to create a new column in hauled that returns the values from summary$rfp_id based on 2 matching criteria: 1. Match summary$customer_id_num with hauled$customer_id_num 2. Compare hauled$transaction_date with summary$start_date and summary$end_date and return whichever rfp_id most closely matches based on the below explanation of possible outcomes. summary dataframe example: ~rfp_id, ~start_date, ~end_date, ~customer_id_num 1, 12/30/2022, 2/28/2023, 7 2, 4/1/2022, 6/30/2022, 8 3, 7/1/2022, 8/30/2022, 8 4, 1/16/2022, 1/16/2023, 9 5, 1/1/2023, 2/6/2023, 9 hauled dataframe example (rfp_id column is the desired result): ~unique_id, ~customer_id_num, ~transaction_date, ~rfp_id 11, 7, 1/14/2023, 1 12, 8, 7/2/2022, 3 13, 8, 3/20/2022, 2 14, 8, 9/1/2022, 3 15, 9, 1/15/2023, 5 16 , 2, 5/1/2022, x The first example (unique_id = 11) returns rfp_id = 1 since company 7 only appears once in summary and hauled$trans_date of 1/14/2023 falls between the start/end dates of 12/30/2022 and 2/28/2023. The second example (unique_id = 12) returns rfp_id = 3 since the transaction_date of 7/2/2022 falls between 7/1/2022-8/30/2022 (and not between 4/1/2022-6/30/2022 of the other customer_id_num match). The third example (unique_id = 13 ) returns rfp_id = 2 because the transaction_date of 3/20/2022 falls outside both start/end date ranges, however it is closest to the start_date of 4/1/2022. The fourth example (unique_id = 14 ) returns rfp_id = 3 because the transaction_date of 9/1/2022 falls outside both start/end date ranges, however it is closest to the end_date of 8/30/2022. The fifth example (unique_id = 15) returns rfp_id = 5 because when a transaction_date falls between 2 or more start/end date ranges then the rfp_id to return is whichever has the latest end_date The sixth example (unique_id = 16) returns 'x' to rfp_id since hauled$customer_id_num = 2 does not exist in summary$customer_id_num.  ---- The code-block that achieves this must be annotated line-by-line explaining what each line is doing to achieve the result. I do not care which package(s) or approach(es) you use to achieve this provided they are 1) available for free through CRAN 2) able to quickly and efficiently process up to 200,000 rows in the hauled df ---- Freelancer project description: I am looking for an R code expert who can help me with a project involving joining or merging data frames based on two criteria: numerical match and date range evaluation. Purpose: - The main purpose of this project is to identify matching records from multiple sources. Preferred Method: - There is no specific preference for the merging method, so the freelancer can choose the most suitable method (e.g., left join or merge) but code must be able to efficiently process extremely large dataframes (up to 200K rows) Desired Output: - The desired output of this project is to have the original data frames updated with the merged information. Skills and Experience: - Proficiency in R programming language - Strong knowledge of data manipulation and merging techniques - Experience with handling numerical data and date ranges (lubridate; dplyr; tidyverse; etc) - Attention to detail to ensure accurate matching records - Ability to efficiently update original data frames If you have the required skills and experience, please submit your proposal.
Projektin tunnus (ID): 37351821

Tietoa projektista

19 ehdotukset
Etäprojekti
Aktiivinen 7 kuukautta sitten

Haluatko ansaita rahaa?

Freelancerin tarjouskilpailun edut

Aseta budjettisi ja aikataulu
Saa maksu työstäsi
Kuvaile ehdotustasi
Rekisteröinti ja töihin tarjoaminen on ilmaista
Myönnetty käyttäjälle:
Käyttäjän avatar
Hello, I am already working on a similar project, I can be very helpful to you. If you're interested, please reach me on chat. ‐-----‐-----‐-----‐-----‐----- Profile : I'm an experienced statictician and data analyst with expertise in R. I've successfully delivered data-driven insights and custom solutions in my previous works. I'm excited about the opportunity to bring my skills to your project and help you achieve your goals. Let's discuss how I can contribute to your success. Best regards,
$100 CAD 1 päivässä
5,0 (1 arvostelu)
2,5
2,5
19 freelancerit tarjoavat keskimäärin $136 CAD tätä projektia
Käyttäjän avatar
Hey there, Glane here. Hope you're doing well. I can help you in merging your files using desired columns and conditions in RStudio. Feek free to get in touch
$120 CAD 1 päivässä
5,0 (41 arvostelua)
5,0
5,0
Käyttäjän avatar
Hello Malcolm, I've read your task description and I think I've found the most suitable algorithm to solve the problem. I have experience with R programming and familiar with its data and date manipulation packages such as lubridate, Tidyverse etc. I am optimistic that this can be completed within 3 days. Many Regards, Chigozie Nkwocha
$170 CAD 3 päivässä
5,0 (18 arvostelua)
4,7
4,7
Käyttäjän avatar
Hi there, My self Muhammad I just check attachment file understand what you want Will finish in next 40 hours for more clear please come to the chat box so we can easily discuss in details Thank you
$235 CAD 1 päivässä
5,0 (5 arvostelua)
4,1
4,1
Käyttäjän avatar
Hello, I am delighted to have come across your project post and express my sincere interest in working with you. As an experienced contractor, I am confident that I possess the skills and expertise required to deliver exceptional results on this project. Over the last decade, I have completed numerous projects similar to yours, and I am confident that I can handle tasks that demand exceptional skills, such as; Algorithm Pattern Matching Data Science Data Analytics Big Data To ensure we can both get a better understanding of the project requirements, budget, and deadlines, I would love to schedule a chat or message to discuss these aspects further. I am available at your convenience and look forward to hearing from you soon. In the meantime, I kindly request that you keep me in mind for future projects in case this one is no longer available. Finally, as a freelancer, I firmly believe that data is the pollution problem of the information age, and protecting privacy is an environmental challenge. Therefore, I take all necessary precautions to safeguard the confidential information you may share with me during the project. Thank you for your time and consideration, and I look forward to working with you. Best Regards, Emma A
$120 CAD 3 päivässä
4,7 (7 arvostelua)
4,5
4,5
Käyttäjän avatar
Hi there, ★★★ C / C++ / R Expert ★★★ 7+ Years of Experience ★★★ I've read requirements and ready to update original data frames with merged information. I have strong grasp on Object-Oriented Programming along with excellent analytical and program-solving skills. What we can do but not limited to: ✔️ Debugging & Solving Problems ✔️ Pointers ✔️ Abstract Classes and Objects ✔️ Constructors and Destructors ✔️ Operator Overloading ✔️ Inheritance, Polymorphism ✔️ Data structures (DSA) ✔️ Functions Overriding and Overloading ✔️ File handling, Streams ✔️ Algorithm Analysis ✔️ Linked Lists ✔️ Stacks and Queues ✔️ Recursion Development Tools: Visual Studio, Code Blocks, Dev c++, Turbo, Netbeans, Eclipse etc As the requirements on project are not complete and need discussion so i placed tentative bid. To provide you the best quote, let's have a chat! Best Regards, TechPlus Team
$250 CAD 3 päivässä
4,2 (3 arvostelua)
4,2
4,2
Käyttäjän avatar
Hi there, I checked your requirements and guarantee you that i have relevant experience in R it's gonna be done within the next few hours . Let's contact via chat so that I can start work immediately
$90 CAD 1 päivässä
5,0 (6 arvostelua)
3,3
3,3
Käyttäjän avatar
I have bachelor's and Master degree in statistics. I am an expert statistician, Research Writer, and data analyst with more than five years of experience. I have full command of Excel analysis, SPSS, STATA, R LANGUAGE, AND PYTHON. I am an expert in creating time series prediction models, working with survey data, conducting marketing analysis, building estimators, and medical analysis. I am a perfect match for your project share other details of the work so I can start working on your project. Will complete task on time.
$100 CAD 2 päivässä
4,8 (2 arvostelua)
3,0
3,0
Käyttäjän avatar
Hi Good evening, I have a creative and innovative mindset hence I guarantee to bring fresh ideas and perspectives to this project. As an experienced freelancer with a strong background in Data Analytics, Algorithm, Big Data, Pattern Matching and Data Science, I am confident that I am the perfect fit for your project. However, I have a few questions that I would like to seek clarification. I look forward to discussing further details and showcasing my portfolio to demonstrate my capabilities. Please chat me. Thanks Malcolm W.
$34 CAD 1 päivässä
4,6 (1 arvostelu)
2,8
2,8
Käyttäjän avatar
Hi Malcolm W., Good morning! I am professional datascientist with skills including Pattern Matching, Big Data, Data Analytics, Algorithm and Data Science. I hold an masters degree in data analysis which provides me with the necessary background to handle your project. Having done similar projects, I can deliver quality and superior work at a price we are both comfortable with and within the agreed timeline. Meanwhile, I am currently reviewing your attachment. I will update you shortly in the inbox once you respond to my proposal. Please send a message to discuss more regarding this project. Thanks & Regards, Lincoln
$100 CAD 1 päivässä
5,0 (3 arvostelua)
2,4
2,4
Käyttäjän avatar
Hi! I can do your r code - left join or merge between data frames based on 2 criteria: numerical match and date range evaluation job at a friendly price with no errors. My experience with Pattern Matching, Data Analytics, Big Data, Data Science and Algorithm makes me the right person to help you complete this project. I am available to start immediately upon your approval. Message me for further discussions on this project. Thank you Malcolm W. for your consideration. I appreciate Carolyne
$140 CAD 1 päivässä
0,0 (0 arvostelua)
2,3
2,3
Käyttäjän avatar
Greetings, I have a comprehensive understanding of your requirements and am well-equipped to provide you with an R code solution for merging data frames based on numerical matches and date range evaluation. I can efficiently handle large data frames and make use of packages such as dplyr, lubridate, and tidyverse to achieve the desired results. I will create a detailed annotated code that explains each step in the process, ensuring accurate matching records and effective data merging. Please consider my proposal, and I look forward to discussing the project in more detail. Best regards, Zafar
$100 CAD 2 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
I understand that you are looking for an R code expert who can help you with a project involving joining or merging data frames based on two criteria: numerical match and date range evaluation. I believe I am the best fit for this project due to my extensive experience in data manipulation and merging techniques as well as attention to detail when it comes to matching records. My skills include R programming language, data manipulation and merging techniques and dealing with numerical data. Additionally, I am experienced in using lubridate and dplyr packages which can be effectively used for large-scale processing (up to 200K rows). If you choose me for this project, you can count on me to deliver accurate results within the specified timeframe. Please feel free to reach out if you have any questions or would like more information about my profile or project description. Thank you for considering me for this opportunity!
$140 CAD 7 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
I offer a blend of expertise and dedication. With a strong background in Big data stacks, I'm well-equipped to deliver exceptional results for your project. I understand the importance of efficiently processing large datasets and will leverage my proficiency in spark with R to meet your requirements. My attention to detail ensures accurate data matching. I'm committed to delivering high-quality work within the specified time frame. As a professional, I offer flexibility, clear communication, and a collaborative approach. Your project's success is my priority, and I look forward to the opportunity to contribute to your data merging and analysis needs.
$50 CAD 3 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
My experience and calibur will match your requirements with ease since I am new to this platform so I will not take you and your work on granted.
$140 CAD 7 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
Greetings Dear Client, Welcome to my profile, Home to Professional and Quality services with 100% customer satisfaction guarantee. I'm a Certified & Experienced Expert in the respective project requirements. Dear Client, I take this opportunity to inform you that i have KEENLY gone through all your project requirements as given in your project description and I confirm to you that i can perfectly deliver as instructed. Being in possession of all CLEARLY STATED required project skills (Data Analytics, Big Data, Algorithm, Pattern Matching and Data Science) as this is my area of professional specialisation having completed all Certifications and developed adequate experience in the same area, I hereby humbly request you to consider my bid for Professional, Quality and Affordable services always. STRICT TIMELY DELIVERY & UNLIMITED REVISIONS. Kindly Message Me We Discuss More About The Project and seal the contract. Welcome and Thank-you.
$250 CAD 1 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
Let me handle this for you! I have experience of handling these type of projects in my previous job.
$140 CAD 7 päivässä
0,0 (0 arvostelua)
0,0
0,0

Tietoja asiakkaasta

Maan CANADA lippu
Toronto, Canada
5,0
4
Maksutapa vahvistettu
Liittynyt heinäk. 18, 2014

Asiakkaan vahvistus

Kiitos! Olemme lähettäneet sinulle sähköpostitse linkin, jolla voit lunastaa ilmaisen krediittisi.
Jotain meni pieleen lähetettäessä sähköpostiasi. Yritä uudelleen.
Rekisteröitynyttä käyttäjää Ilmoitettua työtä yhteensä
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Ladataan esikatselua
Lupa myönnetty Geolocation.
Kirjautumisistuntosi on vanhentunut ja sinut on kirjattu ulos. Kirjaudu uudelleen sisään.