Find Jobs
Hire Freelancers

Python Panda: Modify Dataframe with mask and create new Dataframe

$30-250 USD

Cerrado
Publicado hace más de 1 año

$30-250 USD

Pagado a la entrega
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 del proyecto: 34781215

Información sobre el proyecto

41 propuestas
Proyecto remoto
Activo hace 1 año

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
41 freelancers están ofertando un promedio de $168 USD por este trabajo
Avatar del usuario
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 en 5 días
4,9 (125 comentarios)
6,7
6,7
Avatar del usuario
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 en 5 días
4,9 (86 comentarios)
6,8
6,8
Avatar del usuario
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 en 3 días
4,9 (26 comentarios)
6,6
6,6
Avatar del usuario
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 en 7 días
4,9 (35 comentarios)
6,6
6,6
Avatar del usuario
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 en 3 días
5,0 (13 comentarios)
5,4
5,4
Avatar del usuario
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 en 7 días
4,9 (28 comentarios)
5,6
5,6
Avatar del usuario
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 en 1 día
5,0 (21 comentarios)
5,1
5,1
Avatar del usuario
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 en 7 días
4,8 (14 comentarios)
5,1
5,1
Avatar del usuario
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 en 3 días
4,3 (17 comentarios)
5,8
5,8
Avatar del usuario
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 en 3 días
4,7 (27 comentarios)
5,3
5,3
Avatar del usuario
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 en 1 día
5,0 (18 comentarios)
4,9
4,9
Avatar del usuario
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 en 3 días
4,4 (32 comentarios)
5,5
5,5
Avatar del usuario
yeah i m expert with the python so as i got your task ready to start work from now
$300 USD en 1 día
4,3 (19 comentarios)
5,4
5,4
Avatar del usuario
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 en 3 días
5,0 (5 comentarios)
4,5
4,5
Avatar del usuario
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 en 2 días
5,0 (6 comentarios)
3,9
3,9
Avatar del usuario
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 en 7 días
5,0 (4 comentarios)
3,1
3,1
Avatar del usuario
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 en 7 días
5,0 (3 comentarios)
3,0
3,0
Avatar del usuario
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 en 7 días
4,8 (11 comentarios)
3,2
3,2
Avatar del usuario
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 en 7 días
5,0 (4 comentarios)
2,8
2,8
Avatar del usuario
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 en 7 días
3,4 (8 comentarios)
3,7
3,7

Sobre este cliente

Bandera de UNITED STATES
new york, United States
5,0
22
Miembro desde sept 4, 2014

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.