Find Jobs
Hire Freelancers

A function that calculates the cumulative average of specified columns

$10-15 USD

Closed
Posted about 1 year ago

$10-15 USD

Paid on delivery
I need someone who has experience working with Python and dataframes. I'm looking for a function that can calculate the cumulative average of specific columns in a given dataframe. The freelancer should be able to provide proof that they have the capability to complete this task. Averages for the most recent n-rows for every unique value (HomeTeam and AwayTeam). if a team does not have up to the quired n-rows, calculate the average based on the existing data. The function takes three arguments: func(curr_data, hist_data, num_matches) and creates new columns with cumulative averages for the specified old columns: URL = [login to view URL] budget: 10$ timeline: 1hr
Project ID: 36496945

About the project

17 proposals
Remote project
Active 1 yr 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 $12 USD for this job
User Avatar
Hello there, I am an Excel expert as I have 5+ years of experience in Excel. I understand your project description. I have reviewed the attached excel sheet and I can do this task for you. Message me now to discuss more details over chat. Your satisfaction is our first priority. Regards Ibrahim Ragab
$10 USD in 1 day
4.9 (45 reviews)
5.4
5.4
User Avatar
Hi, My availability: Immediate. I read your project post of Python Developer.!!!!!!!!!!!! We are experienced full stack python developers with skill sets in - Python, Django, Flask, FastAPI, Jupyter Notebook, Selenium - Web App Development, Data Science, Scrapping, API Development, Authentication, Authorization - SQlAlchemy, PostegresDB, MySQL, SqLite - Web hosting, Docker - Azure, AWS, Digital Ocean, GoDaddy, Web Hosting Please send a message So we can have a quick discussion about your project and proceed further. Looking forward to hearing from you. Thanks
$15 USD in 7 days
4.3 (13 reviews)
3.9
3.9
User Avatar
Hello there! My name is Ritik, and I am a full-stack developer with 4+ years of experience working primarily in Python. I understand you are looking for someone who can calculate the cumulative average of specified columns in a given dataframe. I believe that my background and skills make me the perfect fit for this project and I am ready to provide proof of my capability to complete it. My services include averages for the most recent n-rows for every unique value (HomeTeam and AwayTeam). If a team does not have up to the required n-rows, then calculations are made based on existing data instead. Additionally, I guarantee quality assurance by checking each piece of code for accuracy before delivery; this includes making sure that all required columns are included as well as guaranteeing that there are no errors in the code. I would be delighted to assist you with this project! Please let me know if you would like me to discuss further or need any additional information regarding what I can do for you; I look forward to hearing from you soon!
$13 USD in 7 days
4.9 (4 reviews)
2.9
2.9
User Avatar
As a Python developer with extensive experience working with dataframes, I believe that I am the ideal candidate for this project. I have previously completed projects similar to what you're looking for, which involved working with dataframes, calculating averages, and creating new columns. I have a strong understanding of Python and Pandas, which are essential for handling data and performing calculations on dataframes. Additionally, I have experience working with large datasets, which will be useful in this project. I am confident that I can deliver the required function within the specified budget and timeline. I have a track record of meeting deadlines while delivering high-quality work, and I am committed to ensuring that you are satisfied with the results. I am ready to provide you with proof of my capabilities, including my portfolio and any relevant certificates or degrees. Please consider me for this project, and I look forward to working with you.
$13 USD in 7 days
5.0 (4 reviews)
2.9
2.9
User Avatar
Hello, its Jana Ahmad. I am a Python developer with a strong background in computer programming(EXCEL ADVANCE), a huge knowledgeable in software engineering practice, and a great statistical skills. Also, a Performance-driven and organized professional posing a strong analytical and problem solving skills with ability to make well thought out decisions, handling all assigned works and achieving multitasking deliverables on time. I can do this project right now with 100% accuracy. I am available to start working on it now. I work efficiently and will finish in a timely manner and will provide high quality work. I have and would gladly work on your project. I am waiting to your quick positive reply and if you have any questions, feel free to ask me. I will request you to review my profile, skills, projects and customer feedbacks to confirm that I will be good fit for this job. I would like you to start the chat so we can discuss the project in detail and we will see how it goes. ps. I work as a full time freelancer Thanks and regards, Jana Replies within a few hours
$10 USD in 1 day
5.0 (3 reviews)
2.7
2.7
User Avatar
Dear Hiring Manager, In response to your job posting, I am writing to express my interest in the freelance job. I have a strong background in working with Python and dataframes, and I am familiar with functions that can calculate the cumulative average of specific columns. I am able to provide proof of my capabilities, and I am confident that I can complete this task in a timely and efficient manner. The proposed function takes three arguments: curr_data, hist_data, and num_matches. It creates a new column with the cumulative average for the specified old columns and assigns it to the corresponding row. If a team does not have enough rows to calculate the average, the function will use existing data to calculate the average. I am available for further discussion if you have any questions about my proposal. Thank you for your consideration. Sincerely,
$13 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, Im working as an AI consultant and have over 5 years of experience working with pandas and numpy and over 8 years of experience in Python. I can easily create your function for you with the provided dataset within an hour. Thank you!
$13 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello there...., I can help you with this Python and data frames project. I have experience working with Pandas, which is a powerful library for data manipulation and analysis in Python. To complete this task, I would create a function that takes in the current data, historical data, and the number of matches to calculate the cumulative average for specific columns in the given data frame. The function would first combine the current and historical data frames and then group them by the unique values of HomeTeam and AwayTeam. Next, I would use the rolling() method in Pandas to calculate the cumulative average of the specified columns for the most recent n-rows. If a team does not have up to the required n-rows, the function would calculate the average based on the existing data. Finally, I would create new columns in the data frame to store the cumulative averages for the specified old columns. I am confident that I have the necessary skills and experience to complete this task within the given budget and timeline. Please let me know if you have any further questions or if you would like to proceed with this project. Best regards, [Mohamed]
$10 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, my name is Mahmoud Hamed and I am a data entry and system management specialist with extensive experience. I have the necessary skills to complete your project. Specifically, I have expertise in data processing, Python, and dataframes which will be crucial for calculating the cumulative average of specific columns in a given dataframe. I understand how important it is for you to get this task done as quickly as possible while maintaining accuracy. This is why I would be able to work quickly and efficiently to complete the project within the timeline and budget agreed upon. Moreover, my strong typing skills attention to detail will ensure that all entries are properly formatted so they can be used for analysis without any issue. Please feel free to reach out if you have any questions or would like more information about me or my services. Thank you for considering me for this opportunity!
$13 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Utilized Python libraries Pandas and Numpy to perform complex ETL queries on large datasets, resulting in a significant reduction in processing time and improved data accuracy. · Experience in in building Data Integration, Workflow Solutions and Creating, Configuring, Fine-tuning, Extracting, Transforming, and Loading (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS). · Proficient in designing and scheduling complex SSIS packages for transferring data from multiple data sources and integrate data based on business logic and to load it in data warehouse. · Expert in creating and modifying different types of ad-hoc reports including parameterized, linked, drilldown, drill-through, sub-report, matrix, tabular, and dashboard reports as well as Reports with complex join Queries in SSRS; in depth experience in creating multiple levels cascading prompt for both static and dynamic parameters. · Mastered the ability to design and deploy rich graphic visualizations with drill down and dropdown menu option and parameters using Power BI. · Good experience in implementing dash boarding, data visualizations and analytics using Power BI desktop and server.
$13 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, my name is Nerdeen. I have experience working with Python and dataframes. I understand you need someone who can calculate the cumulative average of specific columns in a given dataframe. My skills include data analysis, data analytics, data processing and more. With these skills I am confident that I can provide the necessary solution for your project. Please feel free to reach out if you have any questions or would like more information about me or my services.
$13 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I have hands-on experience in the field in which I am applying. I have been doing the same for 4 years and also completed an internship in Data Science, where the same has been covered to more extent.
$13 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I read your project about writing function code that can calculate the cumulative average of specific columns in a given dataframe. I am Professional Data Analyst and I can do your project in timely manner. I am Python Developer and I am familiar with Pandas and NumPy libraries. I am waiting to hear from you soon.
$12 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi there I'm Mehedi Hasan . I'm a data entry expert. I will do your work very carefully. Hope you will be satisfied with me. Have a good day.... Thank you.....
$13 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of NIGERIA
Abuja, Nigeria
5.0
100
Payment method verified
Member since Sep 17, 2020

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.