source
https://pandastutor.com/index.html
Hello everyone , I'm Junxin .
Pandas
It is a common tool of data mining , It is very important to master the functions in the process of use . This paper will use the process of Visualization , Explain Pandas
Various operations of .
(dogs[dogs['size'] == 'medium']
.sort_values('type')
.groupby('type').median()
)
Execution steps :
size List and filter out departments and branches
Then convert the type of the row
according to type Columns to group , Calculate the median
dogs['longevity']
dogs.groupby('size').mean()
Execution steps :
Set the data according to size Grouping
Aggregate within a group
dogs.groupby(['type', 'size'])
(dogs
.sort_values('size')
.groupby('size')['height']
.agg(['sum', 'mean', 'std'])
)
Execution steps
according to size Columns sort the data
according to size Grouping
For within group height Calculate
df.loc[:, df.loc['two'] <= 20]
dogs.loc[(dogs['size'] == 'medium') & (dogs['longevity'] > 12), 'breed']
dogs.drop(columns=['type'])
ppl.join(dogs)
ppl.merge(dogs, left_on='likes', right_on='breed', how='left')
dogs.pivot_table(index='size', columns='kids', values='price')
dogs.melt()
dogs.pivot(index='size', columns='kids')
dogs.stack()
dogs.unstack()
dogs.reset_index()
dogs.set_index('breed')
All rivers and mountains are always in love , Order one OK? .
【 Hard core dry goods 】Pandas Data type conversion in modules
Python Eight schemes to realize timed tasks , Dry cargo is full.
recommend 7 A commonly used Pandas Time series processing function
One time summary :64 A common term for data analysis !
A diagram that Xiaobai can understand SQL Basic knowledge of
The basic concepts of statistics that data analysts know
··· END ···
Share 、 Collection 、 give the thumbs-up 、 I'm looking at the arrangement ?