python for data analysis 2nd edition

RT reply: I strongly recommend the python course at rice University. The course is well designed and the teacher is very responsible. ----------------------------------------------------------- Answer questions by phone last night. Update the questions today; There are a total of three courses at Rice University, which now seems to have been divided into six. Each course lasts for 8 weeks in a simple order. The first course is the basics of

[Python Data analysis notes-data loading and finishinghttps://mp.weixin.qq.com/s?__biz=MjM5MDM3Nzg0NA==mid=2651588899idx=4sn= bf74cbf3cd26f434b73a581b6b96d9acchksm= bdbd1b388aca922ee87842d4444e8b6364de4f5e173cb805195a54f9ee073c6f5cb17724c363mpshare=1scene=1 srcid=0214nftjpp2oedvrgrjis3mxpass_ticket=fm74de5nrjn2tpc44mn3

-----15:18 2016/10/14-----1.Import NumPy as Np;import pandas as Pdvalues = PD. Series (Np.random.normal (0,1,size=2000))#Series可看作一个定长的有序字典.The probability density function corresponding to the Gaussian distribution corresponds to the numpy:Np.random.normal (Loc=mu, Scale=sigma, Size=non) standard normal distribution (mu=0,sigma=1) np.random.normal (loc=0, scale=1, Size=non) Values.hist (bins=100, alpha=0.3, color= ' K ', normed= True) #bins interval number alpha Transparency normed=true paramet

data conversion refers to filtering, cleaning, and other conversion operations on the data. Remove Duplicate data Repeating rows often appear in the Dataframe, Dataframe provides a duplicated () method to detect whether rows are duplicated, and another drop_duplicates () method to discard duplicate rows:Duplicated () and Drop_duplicates () methods defaultJudgi

Rt Reply content:I highly recommend the Python class at Rice University, which is very well designed and the teacher is very responsible. ----------------------------------------------------------- Last night mobile phone answer, updated today; Rice University has a total of 3 courses, now seemingly dismantled into 6 doors, 8 weeks per course, according to the order of the more-than-digest. The first course is the

1. Read and write data in text formatPandas provides some functions for reading tabular data as dataframe objects.File import, using Read_csv to import data into a dataframedf= pd.read_csv ('b:/test/ch06/ex1.csv') dfout[142]: a B c D message0 1 2 3 4 hello1 5 6 7 8 world2 9 ten foo Read_table, just need to make a delimiterDF = pd.read_table (

('key1'). STD () # also has count (), sum (), mean (), median () Std,var, Min,max,prod,first,last#可以自定义函数Df.groupby (' Key1 '). Agg ([Lambda X:x.max ()-x.min (), NP.MEAN,NP.STD])# You can customize the function df.groupby ('key1'). Agg ([' Custom Function ', Lambda X:x.max ()-x.min ()), (' mean ', Np.mean), (' standard deviation ') , NP.STD)])#不同列做不同的动作, one takes the maximum value, one takes the minimum valueDf.groupby (' Key1 '). Agg ({' data1 ': Np.max, ' data2 ': np.min})Df.groupby (' Key

resample: resampling function that can increase or decrease the sampling frequency by time, Fill_method can use different filling methods.Freq parameter enumeration for Pandas.data_range: Alias Description B Business Day Frequency C Custom Business Day Frequency D Calendar Day Frequency W Weekly frequency M Month End Frequency Sm Semi-month End Frequency (1

','a','b','a'],'data1': Range (6)}) DF2=PD. DataFrame ({'Key':['a','a','C','b','D'],'data2': Range (5)}) Pd.merge (Df1,df2,on='Key', how=' Right') back to key data1 data20B0.0 31B2.0 32B4.0 33C1.0 24A3.0 05A5.0 06A3.0 17A5.0 18D NaN4Many-to-many merges produce a Cartesian product of rows, that is, DF1 has 2 a,df2 with 2 A, and rallies produce 4 aWhen you need to merge from multiple keys, simply pass in a list of column names.When merging operations, you need to handle dup

A lot of programming in data analysis and modeling is used for data preparation: onboarding, cleanup, transformation, and remodeling. Sometimes, the data stored in a file or database does not meet the requirements of your data processing application. Many people choose to sp

Summary of this section　　Basic EnvironmentIpython FoundationObjectiveThis is the first blog in 18, because boss for some of my job expectations, need to start doing some data analysis work, so began to write this series of blog. The main content of the classification is basically the landlord in view of the reading "Data anal