Apr-23-2018, 01:20 AM
I am banging my head against the wall!!! I'm very new to Python and thought I'd actually run through some tutorials using the kind of data I'll be working with... I've tried several ways of importing my CSV files using both Numpy and Pandas, with errors every time!!!
column 1 is date, column 2 is Time WITH milliseconds, and the rest of the columns are all various numbers. Column 1 and 2 are only used for plotting the data its all the numbers columns that actually need to be analized... here is basically the format of the CSV files... I know column 1 and 2 need to be strings and Ideally I would merge them into 1 column... but I just want to be able to start doing something with my data... Biggest issue is getting Pandas to recognize and convert dates and times.
2017/6/13, 09:39:12.0, 5813.00, 5813.75, 5812.50, 5813.75, 189, 146
2017/6/13, 09:39:17.0, 5814.00, 5814.75, 5810.50, 5814.25, 940, 700
2017/6/13, 09:39:49.0, 5814.75, 5815.50, 5814.00, 5815.50, 289, 203
2017/6/13, 09:40:01.0, 5815.50, 5816.25, 5814.75, 5816.25, 647, 446
ANY ADVICE APPRECIATED!!!
column 1 is date, column 2 is Time WITH milliseconds, and the rest of the columns are all various numbers. Column 1 and 2 are only used for plotting the data its all the numbers columns that actually need to be analized... here is basically the format of the CSV files... I know column 1 and 2 need to be strings and Ideally I would merge them into 1 column... but I just want to be able to start doing something with my data... Biggest issue is getting Pandas to recognize and convert dates and times.
2017/6/13, 09:39:12.0, 5813.00, 5813.75, 5812.50, 5813.75, 189, 146
2017/6/13, 09:39:17.0, 5814.00, 5814.75, 5810.50, 5814.25, 940, 700
2017/6/13, 09:39:49.0, 5814.75, 5815.50, 5814.00, 5815.50, 289, 203
2017/6/13, 09:40:01.0, 5815.50, 5816.25, 5814.75, 5816.25, 647, 446
ANY ADVICE APPRECIATED!!!