title: Plotting a heatmap using CSV file data in python
body: <p>I have output nested dictionary variable called <strong>all_count_details_dictionary</strong>. Using that variable I saved data to the CSV file using the following command.</p>
  <pre><code>import pandas as pd
  csv_path = '../results_v6/output_01.csv'
  # creating pandas dataframe using concat mehtod to extract data from dictionary
  df = pd.concat([pd.DataFrame(l) for l in all_count_details_dictionary],axis=1).T
  
  # saving the dataframe to the csv file
  df.to_csv(csv_path, index=True)
  </code></pre>
  <p>The output CSV file is just like as below</p>
  <p><a href="https://i.stack.imgur.com/cF5fa.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/cF5fa.jpg" alt="enter image description here" /></a>
  The CSV file can be download using this <a href="https://drive.google.com/file/d/1rzKJniGBOgNBw7EN3cv3TD6I40p4jTil/view?usp=sharing" rel="nofollow noreferrer">link</a></p>
  <p>So I used the following code to plot a graph</p>
  <pre><code>import matplotlib.pyplot as plt
  
  def extract_csv_gen_plot(csv_path):
  
      length = 1503 #len(dataframe_colums_list)
      data = np.genfromtxt(csv_path, delimiter=&quot;,&quot;, skip_header=True, usecols=range(3, (length+1)))
      print(data)
  
      # renaming data axes
      #fig, ax = plt.subplots()
      #fig.canvas.draw()
  
      #labels =[item.get_text() for item in ax.get_xticklabels()]
      #labels[1] = 'testing'
      #ax.set_xticklabels(labels)
  
      #ax.set_xticklabels(list)
      #ax.set_yticklabels(list)
      #plt.setp(ax.get_xticklabels(), rotation = 90)
  
  
      plt.imshow(data, cmap='hot',interpolation='nearest')
      plt.show()
  </code></pre>
  <p>I tried to get the column labels and case details labels into the graph axes, but it doesn't work out. Can anyone please tell me there is any other best method to plot this table into a heat map than this?</p>
  <p>Thank you!</p>