Find Jobs
Hire Freelancers

Python Panda: Modify Dataframe with mask and create new Dataframe

$30-250 USD

Ditutup
Disiarkan lebih dari 1 tahun yang lalu

$30-250 USD

Dibayar semasa penghantaran
I have the following df of 10 million rows: Super speed is essential to this project, so please only apply if you know the fastest techniques to do this project. date price MA1 MA2 MA3 date0 price0 12 10 8 date1 price1 11 11 11 date2 price2 12 21 14 date3 price3 13 12 15 date4 price4 14 14 14 date5 price5 15 17 14 date6 price6 19 16 15 date7 price7 15 12 13 date8 price8 11 10 13 date9 price9 21 12 13 date10 price10 13 11 14 date11 price11 14 14 14 date12 price12 16 16 16 date13 price13 34 32 23 date14 price14 12 12 12 I have the following df: date price MA1 MA2 MA3 date0 price0 12 10 8 date1 price1 11 11 11 date2 price2 12 21 14 date3 price3 13 12 15 date4 price4 14 14 14 date5 price5 15 17 14 date6 price6 19 16 15 date7 price7 15 12 13 date8 price8 11 10 13 date9 price9 21 12 13 date10 price10 13 11 14 date11 price11 14 14 14 date12 price12 16 16 16 date13 price13 34 32 23 date14 price14 12 12 12 I filter my df using the following mask: df =(data .assign(same=lambda x: (x['MA1'] == x['MA2']) & (x['MA1'] == x['MA3'])) .loc[lambda x: [login to view URL] == True] ) I get: date price MA1 MA2 MA3 date1 price1 11 11 11 date4 price4 14 14 14 date11 price11 14 14 14 date12 price12 16 16 16 date14 price14 12 12 12 So the dates where MA1, MA2 and M3 are matching are date1, date4, date11, date 12, date14. I would like to create a df which matches this format date price price_past price_fut return_past return_future date1 price1 price0 price2 (price1-price0)/price0 (price2-price1)/price1 date4 price4 price3 price5 (price4-price3)/price3 (price5-price4)/price4 date11 price11 price10 price12 (price11-price10)/price10 (price12-price11)/price11 date12 price12 price11 price13 (price12-price11)/price11 (price13 -price12)/price12 date14 price14 price13 price15 (price14-price13)/price13 (price15-price14)/price14 Then i want to get statistics on the number of rows where returns are of the same sign. (percentage, counts, etc..) I would like then to extend the number of lookback and forward looking prices i incorporate in the statistic computation.. So for instance here I use 1 price back 1 price forward. I would like to be able to set the number of how many prices I choose to select. Thanks
ID Projek: 34781215

Tentang projek

41 cadangan
Projek jarak jauh
Aktif 1 tahun 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
41 pekerja bebas membida secara purata $168 USD untuk pekerjaan ini
Avatar Pengguna
Hello, I am Python developer and I have created performant scripts in Pandas, I think I can do what you need efficiently. Let me recap what I get from your description, you still want your formula to be applied so that you filter the dates where MA1, MA2 and M3 match, and then you want to create a new dataframe with these matches but it will also use the prices from the original Dataframe for the lookback and forward calculations. And you want this to be dynamic. I understand that some optimization will be necessary if the dataframes are really big. Let me know if there is something I miss. Call me Thanassis, thank you
$230 USD dalam 5 hari
4.9 (125 ulasan)
6.7
6.7
Avatar Pengguna
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 850 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion.. Thank you Sandeep
$220 USD dalam 5 hari
4.9 (86 ulasan)
6.8
6.8
Avatar Pengguna
Hi there,I'm biddin on your project "Python Panda: Modify Dataframe with mask and create new Dataframe" I have read your project description and i'm an expert in Python and machine learning therefore i can do this project for you perfectly.I still have a few questions. please leave a message on my chat so we can discuss the budget and deadline of the project. Thanks. .. .
$250 USD dalam 3 hari
4.9 (26 ulasan)
6.6
6.6
Avatar Pengguna
Hi Mate, I am glad to inform you that we have a strong 6+ years of quality experience in Software Development. I do have the necessary skill set & resources to complete this project. I have done this kind of project before and I am ready to start the project. I can certainly assist you with your project requirements. Let’s have a quick chat to discuss in detail and get the ball rolling. Waiting for your earliest reply. Thank you Virang Patel Bid Amount is just a placeholder, I will share you the best timeline and cost once we are on the same page.
$250 USD dalam 7 hari
4.9 (35 ulasan)
6.6
6.6
Avatar Pengguna
Hi, I am senior python developer. I have great experience with Jupyter, machine learning, speech processing, data processing, image processing, automation, pandas, web scraping and so on. I will do my best to provide the results you are looking for. I want to discuss about the project more. Thanks.
$140 USD dalam 3 hari
5.0 (13 ulasan)
5.4
5.4
Avatar Pengguna
Hi, I am artificial intelligence engineer with more 8 years of experience in Data Science & Machine/Deep Learning Feel free to contact me for further details I have the hardware required to accomplish this job..Bid Amount is just a placeholder, I will share the best timeline and cost once we both will be on the same page. Thank you
$140 USD dalam 7 hari
4.9 (28 ulasan)
5.6
5.6
Avatar Pengguna
Hi. I'm a developer with a decade of experience of using pandas in projects. If I understand your problem correctly, I will be able to create a solution in a few lines of codes within a few hours. It might even beat your current implementation concerning run time. I look forward to working with you Helge Krueger
$50 USD dalam 1 hari
5.0 (21 ulasan)
5.1
5.1
Avatar Pengguna
Hello, Client! Thanks for giving the opportunity to work for you. I have read your project description very carefully, and understood what you want. I have a deep understanding and experience in the areas of python that you mentioned. I've previously worked on so many projects for other employers. Here is my profile URL: https://www.freelancer.com/u/LongVuDinh Check out my past reviews and skills. So, I would like to go through more specific discussions with you to provide successful results. Thank you, Dinh Long.
$140 USD dalam 7 hari
4.8 (14 ulasan)
5.1
5.1
Avatar Pengguna
Hello, I hope this finds you well. I have just seen your project requiring; Python NumPy Pandas I believe that my 10-year experience in this field is what you need right away. Avoid the headache of looking further. Let's save time and focus on the real task. My proposed timelines and budget are just placeholder and an open for negotiation to increase or decrease as per the full requirements at hand. Allow me to prove how better my review can be. Smile all the way! Click the message button, so initiate the conversation. Regards, Fridah
$150 USD dalam 3 hari
4.3 (17 ulasan)
5.8
5.8
Avatar Pengguna
Hello, I read your description carefully. I have rich experience with Python programming and algorithm research. Your projects seem interesting to me!! I have understood your issue. but I need your database to test. I can make perfect result for you in time. Hope to get reply from you soon. Best regards.
$150 USD dalam 3 hari
4.7 (27 ulasan)
5.3
5.3
Avatar Pengguna
Hi I have 5 years of experience in <<< python >>>, so I became an expert that fits perfectly with your requirement fields. I've read the project description carefully. It would be a great pleasure for me to have the opportunity working with you. ✓ Looking forward to hearing more about your project via chat. Best regards!
$50 USD dalam 1 hari
5.0 (18 ulasan)
4.9
4.9
Avatar Pengguna
Hi, Dear Employer, I have read your job post carefully. I can write clean validated Machine Learning code and make a device-supported M. File. I have over 10+ years of experience at the ✔Machine Learning (ML) ✔Python ✔Matlab ✔C program, ✔C++ program ✔R program, ✔Algorithm ✔Statistics ✔java Please feel free, and you may award me the task; I'd be happy and present you with the best products. Promise to work with 100% accuracy. Let's discuss this further via chat, and I'll start your project right now. Thanks, Al. A.
$500 USD dalam 3 hari
4.4 (32 ulasan)
5.5
5.5
Avatar Pengguna
yeah i m expert with the python so as i got your task ready to start work from now
$300 USD dalam 1 hari
4.3 (19 ulasan)
5.4
5.4
Avatar Pengguna
Hello, I think what you would like for this project is to use Dask instead of Pandas as it will split the data into chunks and do the computations in parallel. Depending on how many cores you have on your machine, this could provide significant improvement in speed. To create the past/future price time series, you simply use the shift function with the number of time periods that you want (+/- 1, +/-2 etc.). I can create a Jupyter notebook for you that explains all of this, shows you how to manipulate the data in the ways that you want and include plots of different statistics so that you have a visualisation of what is going on. Please let me know if your interested. I look forward to the possibility of working with you.
$200 USD dalam 3 hari
5.0 (5 ulasan)
4.5
4.5
Avatar Pengguna
Hi there! I’ve carefully checked your requirements and really interested in this project of Python developer .I will do it in a professional way. I have more than 5 year experience with python/django/selenium. And I have rich experience on Web Scraping and Software development using python. It will my pleasure to work with you. I offer only high quality and fast turnaround within your deadline and needs. WAITING FOR YOU IN CHAT BOX! Thank you.
$150 USD dalam 2 hari
5.0 (6 ulasan)
3.9
3.9
Avatar Pengguna
Hi there I read your post and I really want to work with you, if it is possible. I work as a AI engineer, you can check my profile to proof. I worked a lot of ML/DL projects before. If you want to see, I can show them. Your project is so easy for me, so I can complete it in short time with 100% quality Which type of code formation do you want to receive Jupyter notebook or .py file ? Also can you tell me exactly time ? I GUARANTEE MY WORK. If you don't like my work, I will complete it as you want and it will be free I will wait your response Best regards
$140 USD dalam 7 hari
5.0 (4 ulasan)
3.1
3.1
Avatar Pengguna
Hi! I have full experienced with various python projects for 5 years. I have worked on similar projects, I hope we will discuss more details about your project. I'll do my best for you and I'll give you satisfied results in a short time. Waiting your reply. Best Regards
$100 USD dalam 7 hari
5.0 (3 ulasan)
3.0
3.0
Avatar Pengguna
Expert in Python, Pandas I read project description carefully, and I can provide you python code solution in an hour. I have 5+ years of experience in Python, pandas, solve many complex problem using it. kindly text me in the chat with project details, if left any. thanks.
$140 USD dalam 7 hari
4.8 (11 ulasan)
3.2
3.2
Avatar Pengguna
Hello There ! I have read the job description you posted. I have around 6 years of experience working with similar technologies. I believe I will be a good fit for the job and I am a very hardworking individual. I would love to have a chat with you to discuss further. I look forward to hearing from you. Thanks, Sarwar Sikder
$100 USD dalam 7 hari
5.0 (4 ulasan)
2.8
2.8
Avatar Pengguna
Hi Machine learning tasks https://www.freelancer.com/projects/machine-learning/Route-optimization-SCM https://www.freelancer.com/projects/python/OpenCV-Python-based-Path-Vehicle lets discuss over chat done similar tasks
$250 USD dalam 7 hari
3.4 (8 ulasan)
3.7
3.7

Tentang klien

Bendera UNITED STATES
new york, United States
5.0
22
Ahli sejak Sep 4, 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.