View previous topic :: View next topic |
Author |
Message |
acogbill
Joined: 03 Feb 2008 Posts: 3
|
Posted: Fri Sep 18, 2009 11:40 am Post subject: DPLOT doesn't plot data in .csv files with lots of columns |
|
|
The docs for DPLOT indicate that it will plot data from .csv files with as many as 30 columns, and that this number can be increased by the user. However, I've been trying to plot data from a .csv file with 32 cols, without success. I increased the max cols to 50 without any change in behavior. If I reduce the number of cols to a small number (3 to 5 always seem to work), I don't have any problem. I haven't tried all combinations between 5 and 32. If some columns contain alphanumeric data (not merely numbers), does this confuse DPLOT, even when such columns are not to be plotted?
What happens when the number of columns is large is that either no data or, perhaps, a single data point of (0,0) is read.
Separately, originally the .csv file had a column for DATE and a column for TIME, each comma-delimited. DPLOT reads this as a single column of DATE TIME. Perhaps this is intentional. |
|
Back to top |
|
|
DPlotAdmin Site Admin
Joined: 24 Jun 2003 Posts: 2310 Location: Vicksburg, Mississippi
|
Posted: Fri Sep 18, 2009 1:11 pm Post subject: |
|
|
DPlot will read up to 101 columns (X + 100 Y columns). My guess is the problem you're having is related to this:
Quote: | If some columns contain alphanumeric data (not merely numbers), does this confuse DPLOT, even when such columns are not to be plotted?
|
That should work unless some entries in those columns CAN be interpreted as numbers, while others cannot. In that case DPlot will continuously decide that the previous rows must have been a header, and start over. You are welcome to send me a CSV file you're having trouble with. I'll either fix things so that it will work, or tell you what the problem is.
Quote: | Separately, originally the .csv file had a column for DATE and a column for TIME, each comma-delimited. DPLOT reads this as a single column of DATE TIME. Perhaps this is intentional. |
Yes, that is intentional. _________________ Visualize Your Data
support@dplot.com |
|
Back to top |
|
|
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
|