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

Selesai
Disiarkan 7 bulan yang lalu

$30-250 CAD

Dibayar semasa penghantaran
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.
ID Projek: 37351821

Tentang projek

19 cadangan
Projek jarak jauh
Aktif 7 bulan yang lalu

Ingin menjana wang?

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda
Dapatkan bayaran untuk kerja anda
Tuliskan cadangan anda
Ianya percuma untuk mendaftar dan membida pekerjaan
Dianugerahkan kepada:
Avatar Pengguna
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 dalam 1 hari
5.0 (1 ulasan)
2.5
2.5
19 pekerja bebas membida secara purata $136 CAD untuk pekerjaan ini
Avatar Pengguna
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 dalam 1 hari
5.0 (41 ulasan)
5.0
5.0
Avatar Pengguna
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 dalam 3 hari
5.0 (18 ulasan)
4.7
4.7
Avatar Pengguna
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 dalam 1 hari
5.0 (5 ulasan)
4.1
4.1
Avatar Pengguna
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 dalam 3 hari
4.7 (7 ulasan)
4.5
4.5
Avatar Pengguna
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 dalam 3 hari
4.2 (3 ulasan)
4.2
4.2
Avatar Pengguna
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 dalam 1 hari
5.0 (6 ulasan)
3.3
3.3
Avatar Pengguna
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 dalam 2 hari
4.8 (2 ulasan)
3.0
3.0
Avatar Pengguna
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 dalam 1 hari
4.6 (1 ulasan)
2.8
2.8
Avatar Pengguna
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 dalam 1 hari
5.0 (3 ulasan)
2.4
2.4
Avatar Pengguna
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 dalam 1 hari
0.0 (0 ulasan)
2.3
2.3
Avatar Pengguna
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 dalam 2 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
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 dalam 7 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
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 dalam 3 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
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 dalam 7 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
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 dalam 1 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
Let me handle this for you! I have experience of handling these type of projects in my previous job.
$140 CAD dalam 7 hari
0.0 (0 ulasan)
0.0
0.0

Tentang klien

Bendera CANADA
Toronto, Canada
5.0
4
Kaedah pembayaran disahkan
Ahli sejak Jul 18, 2014

Pengesahan Klien

Terima kasih! Kami telah menghantar pautan melalui e-mel kepada anda untuk menuntut kredit percuma anda.
Sesuatu telah berlaku semasa menghantar e-mel anda. Sila cuba lagi.
Pengguna Berdaftar Jumlah Pekerjaan Disiarkan
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuatkan pratonton
Kebenaran diberikan untuk Geolocation.
Sesi log masuk anda telah luput dan telah dilog keluar. Sila log masuk sekali lagi.