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

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.

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...

269. Alien Dictionary

Solution This article assumes you already have some confidence with graph algorithms , such as breadth-first search and depth-first searching . If you're familiar with those, but not with topological sort (the topic tag for this problem), don't panic, as you should still be able to make sense of it. It is one of the many more advanced algorithms that keen programmers tend to "invent" themselves before realizing it's already a widely known and used algorithm. There are a couple of approaches to topological sort; Kahn's Algorithm and DFS. A few things to keep in mind: The letters within a word don't tell us anything about the relative order. For example, the presence of the word kitten in the list does not tell us that the letter k is before the letter i . The input can contain words followed by their prefix, for example, abcd and then ab . These cases will never ...

Vinit Khandelwal

Search This Blog