Hello friends I want to do groupby based on city_name, but

Question

Hello friends I want to do groupby based on city_name, but

in such a way that the sum of columns A and B show the frequency of each city.
If I want to explain better, it goes like this: Suppose each city has populations A and B. So the population of a city is equal to: A + B
Now I want to do groupby based on the population of each city and sort according to the population of the city in the output

my table:

city_name ║ A ║ B ║
city1 ║ 2 ║ 6 ║
city2 ║ 5 ║ 4 ║
city1 ║ 6 ║ 3 ║
city2 ║ 1 ║ 9 ║

can you help me please?

0

27.08.2021

12 ответов

11 просмотров

Sajjad Najafi Автор вопроса

A X
Idk much sql so this might be wrong but is the fol...

thank you for replying yes its something like that you said but im in python and pandas library

0

27.08.2021

A X

Sajjad Najafi
thank you for replying yes its something like that...

I don't know python or pandas library either but it seems that the pandas library can take a sql statement as string. You can try passing the above to that. The name being: pd.read_sql_query if you're referring to the pandas library as pd variable. You get a connection to the database, and pass the sql statement as string and the connection to the above function.

0

27.08.2021

Sajjad Najafi Автор вопроса

A X
I don't know python or pandas library either but i...

ok , thanx 🙏🙏🙏

0

27.08.2021

A X

Sajjad Najafi
ok , thanx 🙏🙏🙏

Let us know what the proper SQL to your question looks like once you get it working. That'd be informative.

0

27.08.2021

Sajjad Najafi Автор вопроса

A X
Let us know what the proper SQL to your question l...

I have csv dataframe for this work and we should use pandas groupby for solving i think i can solving this with your first helping: select city_name, sum(a + b) as population, from my_table group by population order by population desc i hope ✔️

0

27.08.2021

A X

Sajjad Najafi
I have csv dataframe for this work and we should ...

Makes sense. A seemingly helpful link then: https://datatofish.com/sql-to-pandas-dataframe/

0

27.08.2021

Sajjad Najafi Автор вопроса

A X
Makes sense. A seemingly helpful link then: https:...

ok thank you ✅

0

27.08.2021

Sajjad Najafi Автор вопроса

A X
Makes sense. A seemingly helpful link then: https:...

I did this: # sum of A, B and store in dataframe as new column: mytable['total_AB']=mytable['A']+mytable['B'] then: mytable.groupby('city_name').sum()['total_AB'].nlargest(5)

0

27.08.2021

A X

Sajjad Najafi
I did this: # sum of A, B and store in dataframe a...

I see.

0

27.08.2021

Sajjad Najafi Автор вопроса

A X
I see.

thank you for helping again

0

27.08.2021

A X

Sajjad Najafi
thank you for helping again

No issues. :)

0

27.08.2021

A X · Accepted Answer

A X

Idk much sql so this might be wrong but is the following not something that you want? select city_name, sum(a + b) as population, from my_table group by population order by population desc

0

27.08.2021

Похожие чаты

Hello friends I want to do groupby based on city_name, but

12 ответов

Похожие вопросы