Mailman 3 December 2022 - Pandas-dev

pandas new infrastructure (OVH donation)
by Marc Garcia Sept. 21, 2024

Sept. 21, 2024

Hi all, pandas has received a donation from OVHcloud <https://www.ovhcloud.com/> to support the project infrastructure, with OVHcloud public cloud credits (an initial amount of 10,000 EUR for a period of one year). OVH is open to sponsor longer term and also other projects of the ecosystem (or NumFOCUS as a whole), but we started with this to have feedback at a smaller scale first. The credits will be used initially for: - Hosting of the pandas website - Running the pandas benchmarks - Speeding up the project CI I detail next what I have in mind to set up for each. If anyone is interested in getting involved, or has ideas, comments... please let me know. I'll publish updates here as there is progress on this. Website: I'm planning to experiment on splitting the website in two (it'll be transparent for users). The website and the stable docs which receive most of the traffic can probably be stored in Cloudflare pages. We're already using Cloudflare as a CDN, so instead of using it as a cache, we can publish the documents there. The rest of the docs (old versions and the dev version) can be hosted in bucket storage of the OVHcloud. Response times may be a bit slower, but our website is bigger than the Cloudflare quota, and having old docs rarely accessed in a CDN seems unnecessary anyway. - Benchmarks: OVHcloud instances have guaranteed hardware, and we'll be checking if this is enough for the results of the benchmarks to be consistent over runs, or if there is too much variability and we need dedicated hardware. If consistency is good enough that would be great, since our benchmarks mostly use one core, and using dedicated hardware is likely to be a decent waste of resources, since most servers will likely have 16 cores or more. We'll discuss with OVH if dedicated hardware is needed, as at the moment their public cloud doesn't offer it (there is an alpha for providing dedicated instances, but we need to check with them). - Faster CI: Our GitHub runners are small, and most builds take around one hour or more to finish. We should be able to use bigger OVH instances for our existing CI pretty easily, via their OpenStack API and CIrun.

5 9

Is it time for a bi-weekly pandas call?
by Marco Gorelli May 13, 2024

May 13, 2024

Currently, there's a monthly pandas call, which has been in place for several years. Seeing as there's now more people working on pandas as part of their jobs, might it be time to increase the frequency? E.g. to meet every 2 weeks, instead of once a month?

6 11

December 2022 monthly community meeting (Wednesday December 14, UTC 18:00)
by Joris Van den Bossche Dec. 13, 2022

Dec. 13, 2022

Hi all, A reminder that the next monthly dev call is tomorrow (Wednesday, December 14) at 18:00 UTC (12:00 central time). Our calendar is at https://pandas.pydata.org/docs/development/meeting.html#calendar to check your local time. The pandas Community Meeting is a regular sync meeting for the project's maintainers which is open to the community. All are welcome to attend! Video Call: https://us06web.zoom.us/j/84484803210?pwd=TjUxNmcyNHcvcG9SNGJvbE53Y21GZz09 Meeting notes: https://docs.google.com/document/u/1/d/1tGbTiYORHiSPgVMXawiweGJlBw5dOkVJLY-… Joris

1 0

Filtering and writing csv of dataframe's mean
by Matheus Saueressig Dec. 3, 2022

Dec. 3, 2022

Hi, So I'm creating a python program that reads a csv file containing some columns with strings and numbers. What I want to do is to select the rows which their column corresponds to a certain type. For example, I want all the rows with the Type "Red". So far so good, I came with this: data1 = dataFrame[dataFrame['Type'].str.contains('red')] Okay, now what I want to do is quite more complicated. I want to select all rows with a specific column destination(For example, West), then I want to make the mean of all individual numerical columns and get one single row with the type Red and West destinatinon which each column(number of apples, number of bananas) its the means of each numerical column. For example: Input: Plane Type Destination Bananas Apples Pineapples A Red West 1 2 3 B Blue West 4 7 3 C Red East 4 5 6 D Green North 7 8 9 E Red East 6 5 7 Output: Type Destination Bananas Apples Pineapples Red West 1 2 3 Red East 5 5 5 Anyone knows how can I proceed the coding?

2 1