How to generate BAR plot using pandas DataFrame?
DATA VISUALIZATION DATA CLEANING PYTHON DATA MUNGING MACHINE LEARNING RECIPES PANDAS CHEATSHEET     ALL TAGS

How to generate BAR plot using pandas DataFrame?

How to generate BAR plot using pandas DataFrame?

This recipe helps you generate BAR plot using pandas DataFrame

0
This python source code does the following: 1. Creates and converts data dictionary into dataframe 2. Groups different horizontal bar graphs for simultaneous comparison 3. Plots the bar graphs by adjusting the position of bars
In [2]:
## How to generate BAR plot using pandas DataFrame
def Snippet_113():
    print()
    print(format('How to use timeseries using pandas DataFrame','*^82'))
    import warnings
    warnings.filterwarnings("ignore")

    # load libraries
    import pandas as pd
    import matplotlib.pyplot as plt
    import numpy as np

    # Create dataframe
    raw_data = {'first_name': ['Jason', 'Molly', 'Tina', 'Jake', 'Amy'],
                'pre_score': [4, 24, 31, 2, 3],
                'mid_score': [25, 94, 57, 62, 70],
                'post_score': [5, 43, 23, 23, 51]}
    df = pd.DataFrame(raw_data, columns = ['first_name', 'pre_score', 'mid_score',
                                           'post_score'])
    print(); print(df)

    # input data, specifically the second and third rows, skipping the first column
    Molly = df.ix[1, 1:]
    Tina = df.ix[2, 1:]

    # Create the bar labels
    bar_labels = ['Pre Score', 'Mid Score', 'Post Score']

    # Create a figure
    plt.figure(figsize=(8,6))

    # Set the y position
    y_pos = np.arange(len(Molly))
    y_pos = [x for x in y_pos]
    plt.yticks(y_pos, bar_labels, fontsize=10)

    # Create a horizontal bar in the position y_pos
    plt.barh(y_pos, Molly, align='center', alpha=0.4, color='#263F13')
    plt.barh(y_pos, -Tina, align='center', alpha=0.4, color='#77A61D')

    # annotation and labels
    plt.xlabel('Tina\'s Score: Light Green. Molly\'s Score: Dark Green')
    plt.title('Comparison of Molly and Tina\'s Score')
    plt.ylim([-1,len(Molly)+0.1])
    plt.xlim([-max(Tina)-10, max(Tina)+10])
    plt.grid(); plt.show()

Snippet_113()
*******************How to use timeseries using pandas DataFrame*******************

  first_name  pre_score  mid_score  post_score
0      Jason          4         25           5
1      Molly         24         94          43
2       Tina         31         57          23
3       Jake          2         62          23
4        Amy          3         70          51

Relevant Projects

Customer Market Basket Analysis using Apriori and Fpgrowth algorithms
In this NLP AI application, we build the core conversational engine for a chatbot. We use the popular NLTK text classification library to achieve this.

Predict Macro Economic Trends using Kaggle Financial Dataset
In this machine learning project, you will uncover the predictive value in an uncertain world by using various artificial intelligence, machine learning, advanced regression and feature transformation techniques.

German Credit Dataset Analysis to Classify Loan Applications
In this data science project, you will work with German credit dataset using classification techniques like Decision Tree, Neural Networks etc to classify loan applications using R.

Mercari Price Suggestion Challenge Data Science Project
Data Science Project in Python- Build a machine learning algorithm that automatically suggests the right product prices.

Natural language processing Chatbot application using NLTK for text classification
In this NLP AI application, we build the core conversational engine for a chatbot. We use the popular NLTK text classification library to achieve this.

Predict Employee Computer Access Needs in Python
Data Science Project in Python- Given his or her job role, predict employee access needs using amazon employee database.

Identifying Product Bundles from Sales Data Using R Language
In this data science project in R, we are going to talk about subjective segmentation which is a clustering technique to find out product bundles in sales data.

Sequence Classification with LSTM RNN in Python with Keras
In this project, we are going to work on Sequence to Sequence Prediction using IMDB Movie Review Dataset​ using Keras in Python.

Perform Time series modelling using Facebook Prophet
In this project, we are going to talk about Time Series Forecasting to predict the electricity requirement for a particular house using Prophet.

Machine Learning or Predictive Models in IoT - Energy Prediction Use Case
In this machine learning and IoT project, we are going to test out the experimental data using various predictive models and train the models and break the energy usage.