import pandas as pd

import numpy as np

import plotly.plotly as py

import plotly.graph_objs as go

path = '/home/v-gazh/PycharmProjects/us_data/counts.csv'

df = pd.read_csv(path)

df['PERMNO'] = df['PERMNO'].map(lambda x : 'P'+str(x) )  # 该了下类型 此行有可无

df.set_index(['PERMNO'], inplace=True)

trace1 = go.Bar(

    x=df.index,

    y=df['tickerCount'].squeeze(),

    name='一个P对应TICKER个数'

)

trace2 = go.Bar(

    x=df.index,

    y=df['exchcdCount'].squeeze(),

    name='一个P对应EXCHCD个数'

)

data = [trace1, trace2]

layout = go.Layout(

    barmode='group'#分组

)

fig = go.Figure(data=data, layout=layout)

py.iplot(fig, filename='grouped-bar')