Plot pandas dates in matplotlib

by

If you use a list containing the column name(s) instead of a string, data.set_index will work

The following should show the dates on x-axis:

#! /usr/bin/env python
import pandas as pd
import matplotlib.pyplot as plt
data = pd.read_fwf('myfile.log',header=None,names=['time','amount'],widths=[27,5])
data.time = pd.to_datetime(data['time'], format="%Y-%m-%d %H:%M:%S.%f")
data.set_index(['time'],inplace=True)
data.plot()

#OR 
plt.plot(data.index, data.amount)

More Related Contents:

  1. Annotate bars with values on Pandas bar plots
  2. Filtering Pandas DataFrames on dates
  3. Pandas Dataframe line plot display date on xaxis
  4. How to print pandas DataFrame without index
  5. Changing the formatting of a datetime axis in matplotlib
  6. datetime dtypes in pandas read_csv
  7. Pandas dataframe groupby plot
  8. Add x and y labels to a pandas plot
  9. python pandas extract year from datetime: df[‘year’] = df[‘date’].year is not working
  10. How to change the datetime tick label frequency for matplotlib plots
  11. Removing the timestamp from a datetime in pandas dataframe
  12. Pandas filter dataframe rows with a specific year
  13. Python/Pandas convert string to time only
  14. How to plot two columns of a pandas data frame using points
  15. Convert Pandas Series to DateTime in a DataFrame
  16. pandas .plot() x-axis tick frequency — how can I show more ticks?
  17. pandas bar plot combined with line plot shows the time axis beginning at 1970
  18. Plot multiple columns of pandas DataFrame using Seaborn
  19. Truncate `TimeStamp` column to hour precision in pandas `DataFrame`
  20. Plot a bar plot from a Pandas DataFrame
  21. Python pandas integer YYYYMMDD to datetime
  22. Xticks by pandas plot, rename with the string
  23. making matplotlib scatter plots from dataframes in Python’s pandas
  24. Group DataFrame in 5-minute intervals
  25. Pandas custom function to find whether it is the 1st, 2nd etc Monday, Tuesday, etc – all suggestions welcome
  26. What values are valid in Pandas ‘Freq’ tags?
  27. Python: Adding hours to pandas timestamp
  28. pandas extract year from datetime: df[‘year’] = df[‘date’].year is not working
  29. Python Pandas : pandas.to_datetime() is switching day & month when day is less than 13
  30. Get weekday/day-of-week for Datetime column of DataFrame

Leave a Comment