group-by

I have a question when working with a table in Pandas. I get everything below #достали из базы данных табличку ... м - 110 17:46 Карп жареный - 240 UPD: I tried to do as in the answer to the question

There is a dataframe: df.head() title birthday today age 0 Group 1 1997-07-24 2020-05-04 8320 days 1 ... , as well as mean and median without grouping: df['age'].median() Timedelta('10684 days 00:00:00') Thank you in advance!

There is an object groupby formed from a DataFrame. For it, you need to calculate the variance by categories in which the num ... 'new'])['amount'] #так был создан объект I try this, but it's the wrong code: megretrans_new.agg(['count' > 10, np.var])

Let's say there is a table df, it has columns with the name "name", "class". Let there be lines named "x". If: df_grouped = ... ) df_one_group = df_one_group[["имя", "класс"]] Why is everything good in the loop, but without it, an error comes out?

I have a DataFrame of this kind: Id| Sex | .... ------------------ 1 |male |.... 2 |female|.... 3 |female|.... 4 |male |. ... ---------- male | 3 female| 2 Tried : df.groupby(['sex']).agg(['mean', 'count']) But it seems that this is not the case

Hello. Question on sql clause GROUP BY. Consider grouping by ONE column. Example: SELECT DEPARTMENT_ID, SUM(SALARY) F ... which it would be clear. I looked through a bunch of articles and books on this subject, but I didn't understand anything.

What information does MySQL give out if you do GROUP BY without group functions? For example: id|name|count|date ---------- ... elds name, count and date or do random values from the sample fall there? P.S. the same PostgreSQL will just throw an error.

Dear colleagues, I ask you to suggest CHADNT? Why ORA-00979: the expression is not a GROUP BY expression? Request: s ... cp.guid = p.cpp_guid where p.payment_date = '01.01.70' and p.is_active = 1 group by cp.name; Thank you very much!

The multilanguage of the site is made by displaying more popular values from the mysql database, which have collected a great ... ith the minimum number of voices, and should output only with the largest number of voices. Help me make the correct query.

I have a DataFrame that contains various values. import pandas as pd df = pd.DataFrame({"data": [1, 1, 1, 1, 0, 0, 0, 2, 2, ... that I'm doing everything wrong. And such issues should be solved much easier. Can you tell me how best to solve my problem?

Good day to all! Please help me understand how GroupBy works and what is the difference in the code below. class Employee { ... at in result1 only the key will consist of a string, but what about when the key should be an object with several properties?

I am using PHP and MySQL, I have two tables in the database: POSTAGEM id ---- 1 3 13 CURTIDA id | id_usuario | id_posta ... s) but lists post 3 (which also has no likes) Here you can see this error in action: http://sqlfiddle.com/#! 9 / 9c0d7c/1

I would like to know if there is a way to group records by the order of presentation of the search. Let's say I have a table ... 4 In this grouping would appear three result Lines: Recife - 3 SãoPaulo - 1 Recife - 1 Is there such a possibility?

Good afternoon. I don't have much skill with Python, I'm having some doubts. Anyone who can help me, since I thank you. I o ... to an "object"format/type. Index | Dia Pedro | 3, 24 Antonio| 24 Carlos | 4, 28 Jose | 1, 2 Could you help me?

I have two tables, one with names of doctors and one with the classifications does care and I want to list the doctors and qu ... the beginning of the query, but it has been running for some time... I can't believe it's gonna work. Could anyone help me?

I have the following tables in my MYSQL database Users table id | login --------------- 1 | usuario1 2 | usuario2 3 | ... | 2018-05-15 10:00:00 | a 3 | 2018-05-25 10:00:00 | a Any idea how I get to this result as efficiently as possible?

Wave, I am trying to join the information of two tables to generate a graph, I need to count the total record Query1 and qu ... | 165 | 0 | | 11 | 164 | 0 | | 12 | 186 | 0 | +------+--------+--------+ Could anyone help me?

this question already has answers here : ... hrough this? Do you know if it could be some server configuration? Is there anything I can use to test or see some error log?

------------------- - TABLE - ------------------- ID | GRUPO | OBJETO ---|-------|------- 1 | 1 | 1 2 | 1 ... ly and Only who bought the mostonly orange and Apple . I don't care what groups orange and Apple are in, so IN doesn't work.