Skip to main content

Playing Around with Pandas, Matplotlib, Seaborn, Plotly, and Cufflinks Functions

Playing Around with Pandas, Matplotlib, Seaborn, Plotly, and Cufflinks Functions.

idxmin() and idxmax()

Pandas allows to get index of min and max using idxmin() and idxmax() respectively.
.std()
Examples:

  • dataframe.idxmin()
  • dataframe.idxmax()

std()

Pandas allows to calculate standard deviation for each column with .std()
Examples:

  • dataframe.std()

.plot()

.plot() directly shows line graph

.iplot()

Similar to plot() but for interactive graphs

.xs()

.xs() is called cross section. Used to get a sub column data. It has following arguments:
  • key - for column name or row name
  • axis - 1 if column, default is 0 for row
  • level - if there is several levels to columns or rows
Example:
  • dataframe.xs(key='Column_name', axis=1, level='Super_column_name')

Plot Moving Average


dataframe['Column name'].rolling(window=30).mean().plot(label='30 day moving average')
dataframe['Column name'].plot(label='30 day moving average')

Plot Candle Chart of a Stock

df_stock = stock[['Open', 'High','Low', 'Close']].ix['2015-01-01':'2016-01-01']
df_stock.iplot(kind='candle')

Comments

Post a Comment

Popular posts from this blog

Python - List - Append, Count, Extend, Index, Insert, Pop, Remove, Reverse, Sort

🐍 Advance List List is widely used and it's functionalities are heavily useful. Append Adds one element at the end of the list. Syntax list1.append(value) Input l1 = [1, 2, 3] l1.append(4) l1 Output [1, 2, 3, 4] append can be used to add any datatype in a list. It can even add list inside list. Caution: Append does not return anything. It just appends the list. Count .count(value) counts the number of occurrences of an element in the list. Syntax list1.count(value) Input l1 = [1, 2, 3, 4, 3] l1.count(3) Output 2 It returns 0 if the value is not found in the list. Extend .count(value) counts the number of occurrences of an element in the list. Syntax list1.extend(list) Input l1 = [1, 2, 3] l1.extend([4, 5]) Output [1, 2, 3, 4, 5] If we use append, entire list will be added to the first list like one element. Extend, i nstead of considering a list as one element, it joins the two lists one after other. Append works in the following way. Input l1 = [1, 2, 3] l1.append([4, 5]) Output...
Post a Comment
Read more

Difference between .exec() and .execPopulate() in Mongoose?

Here I answer what is the difference between .exec() and .execPopulate() in Mongoose? .exec() is used with a query while .execPopulate() is used with a document Syntax for .exec() is as follows: Model.query() . populate ( 'field' ) . exec () // returns promise . then ( function ( document ) { console . log ( document ); }); Syntax for .execPopulate() is as follows: fetchedDocument . populate ( 'field' ) . execPopulate () // returns promise . then ( function ( document ) { console . log ( document ); }); When working with individual document use .execPopulate(), for model query use .exec(). Both returns a promise. One can do without .exec() or .execPopulate() but then has to pass a callback in populate.
1 comment
Read more

Python Class to Calculate Distance and Slope of a Line with Coordinates as Input

🐍  Can be run on Jupyter Notebook #CLASS DESIGNED TO CREATE OBJECTS THAT TAKES COORDINATES AND CALCULATES DISTANCE AND SLOPE class Line:     def __init__(self,coor1,coor2):         self.coor1=coor1         self.coor2=coor2 #FUNCTION CALCULATES DISTANCE     def distance(self):         return ((self.coor2[0]-self.coor1[0])**2+(self.coor2[1]-self.coor1[1])**2)**0.5 #FUNCTION CALCULATES SLOPE         def slope(self):         return (self.coor2[1]-self.coor1[1])/(self.coor2[0]-self.coor1[0]) #DEFINING COORDINATES coordinate1 = (3,2) coordinate2 = (8,10) #CREATING OBJECT OF LINE CLASS li = Line(coordinate1,coordinate2) #CALLING DISTANCE FUNCTION li.distance() #CALLING SLOPE FUNCTION li.slope()
Post a Comment
Read more