i have csv file following format:
10/09/2009,08:16,99.835,99.835,99.835,99.835,2 how call pandas.read_csv on such file parses first 2 columns datetime index?
use parse_dates kwarg in read_csv function. see the docs.
df = pd.read_csv(filepath_goes_here, sep=',', parse_dates={'dt': [0, 1]}).set_index('dt') you can use date_parser kwarg if have dates in nonstandard formats (the ones in example standard).
Comments
Post a Comment