Python – Group By
import pandas as pd
%%
import pandas as pd
%%
df = pd.read_csv('C:\Data\sample_data\california_housing_test.csv')
%%
df
%%
Select 3 columns into into a new dataframe
df1 = df[['longitude','latitude','housing_median_age']]
df1
%%
More than one condition in more than one column
Use one set of conditions or another. The OR operator.
Put this into a new dataframe df2
df2 = df1[
(df1['housing_median_age']==30)
& (df1['latitude']GreaterThan=38.00)
|
(df1['housing_median_age']==40)
& (df1['latitude']GreaterThan=38.00)
]
df2
%%
Group By 1
df2.groupby(['housing_median_age'])['housing_median_age'].count()
%%
Group By 2
df2.groupby(['housing_median_age']).size().reset_index(name='counts')
On this page of the site you can watch the video online Python – Group By with a duration of hours minute second in good quality, which was uploaded by the user sql and py 21 March 2024, share the link with friends and acquaintances, this video has already been watched 2 times on youtube and it was liked by 0 viewers. Enjoy your viewing!
