Python Pandas divide row by groupby mean

Finalizat Postat la acum 2 ani S-au achitat serviciile după ce au fost prestate
Finalizat S-au achitat serviciile după ce au fost prestate

I have a large data set that i need to be able to get the averages $ values of two columns grouped by unique ship names in column A.

I will provide a scaled down data set and the ipynb file i have created so far.

in the data set, i have two tabs.

1. "casino_test_sample" This is how the report comes to me from the system.

2. "final look" This is how i need to to look after the code is run.

As you can see, i was able to remove the columns i dont need and add the columns i do. Its ugly, you may be able to do it cleaner.

I have color coded specific rows and columns in "final look"

Red = i dont want this first column to show in the .csv file

Blue = all used column headings are renamed to match the requirements of the receiver.

Yellow = i need these for the calculation but i dont want them in the "final look".

green = This is the two calculated columns i cannot do myself.

The "COIN_IN_IDX_VS_HS_AVG" is the result of dividing the "ELEC COIN IN AMT" mean value by vessel, into the individual ELEC COIN IN AMT rows to give me an index value.

The "NET_WIN_IDX_VS_HS_AVG" column is the same principle, just using the "TWPD" values.

I have entered an excel formula in columns "Q" and "R" so you can understand how i got these values.

In the end, i want to be able to drop the original "casino_test_sample" into my folder, run my code and spit out the "final look" minus the red and yellow columns.


ID Proiect: #31575041

Detalii despre proiect

23 propuneri Proiect la distanță Activ acum 2 ani

Acordat lui:


Dear employer, Hi As you have described the project completely and very clear with the attached files, I completely got what you need. I can do this project for you. I am completely familiar with Python and Pandas mod Mai multe

%selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD în 1 zi
(29 Recenzii)

23 freelanceri licitează în medie 35$ pentru acest proiect


Python pandas developer I read read your job description and I am pretty sure that I can complete every bit of your requirements. Further details and cost can be discussed in chat

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(90 recenzii)

Hi, Thanks for your job posting! I'm a Python expert with over 10 years of experience and very familiar with pandas. I just read your post carefully and understand fully. Looking forward to work with you. Regards. Olg Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(15 recenzii)

Good day, I will gladly help you with this. Ican start working with the files you provided. We can discuss further details via chat. Greetings Matthias

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 2 zile
(35 recenzii)

Python Expert. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platf Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(29 recenzii)

Hi, There. I am a python expert and I have 7+ years experiences with this job. I will do your job with the highest quality*. I am sure that you will be satisfied with contacting me. Let's make a sample deal, please! L Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 2 zile
(12 recenzii)

Dear. Thanks for your job posting. I am glad to place a bid on here as I am familiar with python and have rich experience about panda. I can help your project right now. I hope we will discuss in more detail about your Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 7 zile
(12 recenzii)

Hi Dear! I already check your description with carefully and very interesting your project. Also I have a development experience of project like your project. Specially I have more than 10 years of experience in softwa Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(2 recenzii)

Hi, bro! I have read your requirement and I noticed that I am appropriate to this project. As a skillful software developer, I have rich experience with C/C++, Java, Python and built many projects like this. I promise Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 6 zile
(1 părere)

Hi, there. I am good at Pandas data processing. I can help you with this project. Best regards, Zoltan

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(1 părere)

Hello Dear! I have read your project description and I can Assist you with your projects. Please initiate a chat to discuss further. I guarantee you 100% satisfaction and support. I am available and ready to start imme Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(0 recenzii)

Hello Thanks for your job posting! I read your job description carefully I am a Python developer and I have with +6 years experience in Pandas I will complete your project in time, perfectly and provide good service I Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(0 recenzii)

Hello, how urgent is the delivery? What deadline can we agree on, as I'm a little busy with my master's tasks.

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 7 zile
(0 recenzii)

Hello there, I'm Junior Data Analyst and I have a lot of experience in Python programming, data wrangling & data visualizations. I have worked on a similar project recently so I think I'll be able to fulfil the require Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 7 zile
(1 părere)

I've been working with Data Science for over 5 years in one of the biggest banks in South America. Your jobs is interesting and can delivered on a short period of time with great quality, tests and results validation. Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(0 recenzii)

Hi, I am Data Science professional role as a consultant. AND I would like work with you. Why am I different? Because I will do the work until I provide value with this work, and that you are satisfied with the work Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 7 zile
(0 recenzii)