pandas rank

Pandas data analysis (data structure) and pandas Data Analysis This article mainly expands pandas data structures in the following two directions: Series and DataFrame (corresponding to one-dimensional arrays and two-dimensional arrays in Series and numpy) 1. First, we will introduce how to create a Series. 1) A sequence can be created using an array. For example

Data analysis and presentation-Pandas data feature analysis and data analysis pandasSequence of Pandas data feature analysis data The basic statistics (including sorting), distribution/accumulative statistics, and data features (correlation, periodicity, etc.) can be obtained through summarization (lossy process of extracting data features), data mining (Knowledge formation ). The. sort_index () method so

, how to do? For more information please go to other blogs, where more detailed instructions are available .Pandas import time data for format conversion　　Draw multiple graphs on one canvas and add legends1 fromMatplotlib.font_managerImportfontproperties2Font = fontproperties (fname=r"C:\windows\fonts\STKAITI. TTF", size=14)3colors = ["Red","Green"]#the color used to specify the line4Labels = ["Jingdong","12306"]#used to specify the legend5Plt.plot (

The previous Pandas array (Pandas Series)-(3) Vectorization, said that when the two Pandas series were vectorized, if a key index was only in one of the series , the result of the calculation is nan , so what is the way to deal with nan ?1. Dropna () method:This method discards all values that are the result of NaN , which is equivalent to calculating only the va

Sometimes you need to do some work on the values in the Pandas series , but without the built-in functions, you can write a function yourself, using the Pandas series 's apply method, You can call this function on each value inside, and then return a new SeriesImport= PD. Series ([1, 2, 3, 4, 5])def add_one (x): return x + 1print s.apply ( Add_one)# results:0 6dtype:int64A chestnut:Names =PD. Serie

Data conversionDelete duplicate elements　　The duplicated () function of the Dataframe object can be used to detect duplicate rows and return a series object with the Boolean type. Each element pairsshould be a row, if the row repeats with other rows (that is, the row is not the first occurrence), the element is true, and if it is not repeated with the preceding, the metaThe vegetarian is false.A Series object that returns an element as a Boolean is of great use and is particularly useful for fil

This article describes how the pandas series with the index index is vectorized:1. Index indexed arrays are the same:S1 = PD. Series ([1, 2, 3, 4], index=['a','b','C','D']) S2= PD. Series ([ten, +, +], index=['a','b','C','D'])PrintS1 +s2a11b22C33D44Dtype:int64Add the values corresponding to each index directly2. Index indexed array values are the same, in different order:S1 = PD. Series ([1, 2, 3, 4], index=['a','b','C','D']) S2= PD. Series ([ten, +,

The pandas Series is much more powerful than the numpy array , in many waysFirst, the pandas Series has some methods, such as:The describe method can give some analysis data of Series :Import= PD. Series ([1,2,3,4]) d = s.describe ()Print (d)Count 4.000000mean 2.500000std 1.290994min 1.00000025% 1.75000050% 2.50000075% 3.250000max 4.000000dtype:float64Second, the bigges

1.rank function Rank calculates the rank of a set of values and returns the numeric type. Rankings may be discontinuous. If there are 5 people, 2 of whom rank first, then rank returns the result: 1 1 3 4 5. As an aggregate function, returns the

Import Pandasimport Pandas as PDCountries = ['Albania','Algeria','Andorra','Angola','Antigua and Barbuda', 'Argentina','Armenia','Australia','Austria','Azerbaijan', 'Bahamas','Bahrain','Bangladesh','Barbados','Belarus', 'Belgium','Belize','Benin','Bhutan','Bolivia']life_expectancy_values= [74.7, 75., 83.4, 57.6, 74.6, 75.4, 72.3, 81.5, 80.2, 70.3, 72.1, 76.4, 68.1, 75.2, 69.8, 79.4, 70.8, 62

0d 3dtype:int64> >> Ser.rank () a 3.5b 2.0c 1.0d 3.5dtype:float64>>> ser.rank (method= ' min ') a 3b 2c 1d 3dtype:float64>>> ser.rank (method= ' Max ') a 4b 2c 1d 4dtype : Float64>>> Ser.rank (method= ' first ') a 3b 2c 1d 4dtype:float64Note that the different method parameters show different positions on the ser[0]=ser[3.The DataFrame .rank(axis=0, method=‘average‘, ascending=True) method has a n