title: Setup the width, size and all of the barchart (seaborn)
body: <p>I have developed a bar plot using seaborn library of python.
  Here the month section is having 3 months only, product section is having plenty of products and according to that quantity is there
  Basically I can tell you all that when I print this dataframe then it gives 979 rows in total
  and maybe products in each month are around 300 or maybe not
  In the barplot the bars are very conjested I can't have a clear view which product has highest sell in one  month</p>
  <p>Here is the code:</p>
  <pre><code>import pandas as pd
  import mysql.connector
  import seaborn as sns
  import matplotlib.pyplot as plt
  
  db_connection = mysql.connector.connect(
    host=&quot;localhost&quot;,
    user=&quot;root&quot;,
    passwd=&quot;&quot;,
    db=&quot;trial&quot;
  )
  
  cursor = db_connection.cursor()
  
  df = pd.read_sql(&quot;select ProductName,Month,Bottle from merge where Bottle&gt;0&quot;,db_connection)
  
  mon=[]
  prod=[]
  quan=[]
  
  for i in df.itertuples():
      mon.append(i.Month)
      prod.append(i.ProductName)
      quan.append(i.Bottle)
  
  dfd = pd.DataFrame({&quot;Month&quot;:mon,&quot;Product&quot;:prod,&quot;Quantity&quot;:quan})
  
  sns.barplot(x=&quot;Month&quot;,y=&quot;Quantity&quot;,hue=&quot;Product&quot;,data=dfd,palette=&quot;Set1&quot;)
  
  plt.show()
  </code></pre>
  <p>Here is the barplot which is coming up while executing this code snippet:</p>
  <p><a href="https://i.stack.imgur.com/nVzt0.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/nVzt0.png" alt="Barplot" /></a></p>
  <p>Please help me out in displaying it more clearly.
  Also tell me how to display the values that are occuring in blocks like structure as its written in database with japanese language and collation used is utf8.</p>