title: seaborn line plots with date on the x axis
body: <p><a href="https://i.stack.imgur.com/x5394.png" rel="nofollow noreferrer">enter image description here</a>
  Hi,</p>
  
  <p>I am trying to recreate some of the covid-19 charts that we have seen. I am using data from the Johns Hopkins database. </p>
  
  <p>The data is arranged so that the city names are in the rows and the columns are dates. A screenshot of the csv file is attached. I want to plot line graphs in seaborn that has days in the x axis and confirmed case by city in the y axis. For some reason, I am unable to re-produce the exponential curves of the death rate. </p>
  
  <p>My code is:</p>
  
  <pre><code>'''loading the file'''
  date_columns = list(range(12,123))
  df_covid_us = pd.read_csv(covid_us_file, parse_dates=date_columns)
  df_covid_us = pd.read_csv(covid_us_file)
  
  '''slicing the columns needed. Province_State and the date columns'''
  df = df_covid_us.iloc[:, np.r_[6, 12:123]]
  df = df[df['Province_State']=='New York']
  
  '''using df.melt'''
  df2 =df.melt(id_vars='Province_State',var_name='Date',value_name='Deaths')
  
  '''plotting using seaborn'''[enter image description here][2]
  sns.lineplot(x='Date',y='Deaths',data=df2, ci=None)
  plt.gca().xaxis.set_major_formatter(mdates.DateFormatter('%Y-%m-%d'))
  plt.gca().xaxis.set_major_locator(mdates.DayLocator(interval=20))
  plt.show()
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/zGUXz.png" rel="nofollow noreferrer">enter image description here</a></p>