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

Resolve: Uncaught TypeError: firebase.database is not a function

If you are getting the error: Uncaught TypeError: firebase.database is not a function Resolve it by including firebase-database.js in your html page as follows: <!-- The core Firebase JS SDK is always required and must be listed first --> <script defer src = "https://www.gstatic.com/firebasejs/6.2.4/firebase-app.js" ></script> <script defer src = "https://www.gstatic.com/firebasejs/3.1.0/firebase-database.js" ></script> That is it. Let me know if this was helpful.
Post a Comment
Read more