Beantwortet
readtable can't get variable names from csv if different number of columns
Try giving a hint. opts = detectImportOptions(filename,'NumHeaderLines',0); T = readtable(filename,opts)

mehr als 8 Jahre vor | 5

| akzeptiert

Beantwortet
Error when synchronizing two time series
Hi, I think this is a simple fix, this code may not do what you think it's doing: t1 = SP(:,1); % is a table I don't thi...

mehr als 8 Jahre vor | 0

Beantwortet
large csv import and split
With a file that's 25GB, you're going to need to break the data up. I recommend using ds = tabularTextDatastore(filename...

mehr als 8 Jahre vor | 0

Beantwortet
Hello .. how to read a text file which is a matrix of [1000x512] order of complex numbers. could anyone please help me over this
Hi Darapu, This worked for me. T = readtable('Extracted_Dry_Tar_Road_prediction_file.txt','Whitespace',' ()'); T.Va...

mehr als 8 Jahre vor | 1

| akzeptiert

Beantwortet
readtable does not allow 'Format' option
Hi Xiaoyu, If you're using R2016b or later, you can specify details like this with spreadsheet import options. opts = de...

mehr als 8 Jahre vor | 0

Beantwortet
Error Message dataread and textread
Hi George TEXTREAD is trying to import numeric data but encountering text fields which cannot be converted. Basically, your f...

mehr als 8 Jahre vor | 1

Beantwortet
Textscan and csv fitness data problem
Hi Using textscan is great if you have files with varying formats or if you need certain special behaviors. I found this on...

mehr als 8 Jahre vor | 0

Beantwortet
Process .csv file, combine first two rows into 1 (text rows) to make them the variables
You could try using <https://www.mathworks.com/help/matlab/ref/detectimportoptions.html detectImportOptions> (R2016b or later) a...

mehr als 8 Jahre vor | 1

Beantwortet
Problems With readtable. Convert string data in datetime with milissecond precision.
Your time seems to have a decimal separator of '.' it's the semicolon that's the issue. t = readtable('Test2.csv','Format',...

fast 9 Jahre vor | 0

Beantwortet
Fast move in datastore (TabularTextDatastore)
Hi Adam, Unfortunately, there's not a way to do this. (And I don't mean with datastore--text files are linear things... to fi...

fast 9 Jahre vor | 2

| akzeptiert

Beantwortet
Subscript indices must either be real positive integers or logicals
Very common error. =) MATLAB arrays start at index = 1. You should see the same error from x(0,:) = 1. In this case, I don't ...

fast 9 Jahre vor | 0

Beantwortet
How to import multiple csv files into one and read it from certain folder?
You can use tabularTextDatatstore to collect the CSV files and read them into one table >> ds = tabularTextDatastore(filepa...

fast 9 Jahre vor | 3

| akzeptiert

Beantwortet
How do I read this csv file in and convert the dates?
Hi, I have two things. The first is that readtable should recognize the format, and return datetimes (assuming you are in a...

fast 9 Jahre vor | 0

| akzeptiert

Beantwortet
Long time to load 40 gig file
"cell array tables" A good bet is that the cell arrays are the issue. Each cell of the array takes a 114 bytes of overhead. W...

fast 9 Jahre vor | 0

Beantwortet
How to avoid variable name warnings when using filenames as variable names
The warning you're seeing comes from READTABLE; it's probably not related to the names of your files (unless those are being sto...

fast 9 Jahre vor | 12

| akzeptiert

Beantwortet
How can I read data from a datastore without knowing the exact data type?
Hi Peixin, I assume you don't know all the possible strings that can appear in this column. The only way I think you can proc...

fast 9 Jahre vor | 1

| akzeptiert

Beantwortet
string inside a table
Try: >> T = readtable(filename,'TreatAsEmpty',{'-'}) Jeremy

fast 9 Jahre vor | 0

Beantwortet
Why does textscan read only 95% of my data file?
textscan can read time-of-day as datetime, having the format d = textscan(fid,'%D%D%f','Delimiter',' ','ReturnOnError',...

fast 9 Jahre vor | 0

Beantwortet
How to turn .txt file into a useful table.
Hi, This is actually pretty simple: >> opts = detectImportOptions('abc.txt','Delimiter','.') >> opts.VariableNames= {...

etwa 9 Jahre vor | 0

Beantwortet
Read Text File and Store in Matrices
If you're using textscan, you might try the parameter "MultipleDelimsAsOne',true with 'Delimiter',' \t' The f...

etwa 9 Jahre vor | 0

Beantwortet
Fastest Way of Opening and Reading .csv Files (Currently using xlsread)
Since you have multiple files, you may want to consider using <https://www.mathworks.com/help/matlab/datastore.html datastore>. ...

etwa 9 Jahre vor | 1

Beantwortet
Textscan won't read the dates with spaces
Hi Per, The issue is that textscan's delimiter is space by default. Parsing happens first, then datatype conversion. In this...

etwa 9 Jahre vor | 1

| akzeptiert

Beantwortet
Import data 800*7 textfile into cell array using textscan
You might also want to consider READTABLE. Each "column" of the file will be imported as a table variable in one array with a co...

etwa 9 Jahre vor | 0

Beantwortet
how to use readtable with excel spreadsheets, skip extra header lines, and read to "end"?
Hi Ian, Without the actual file you're trying to read it's hard to say for sure, but I think I can help. Header lines are assum...

mehr als 9 Jahre vor | 1

Beantwortet
Need to know how to readtable() when file has row 1 variable names and row 2 units and the other rows data
Hi Doug, The good news is that readtable using import options was built for this. I think there might be some confusion on...

mehr als 9 Jahre vor | 1

Beantwortet
Error in using datastore function to read big data
Hi Eric, I'm guessing datastore is running into an issue parsing the file. This often happens when there is a non-number ent...

mehr als 9 Jahre vor | 1

Beantwortet
Textscan with very large .dat files, Matlab keeps crashing
Hi, If you can access R2014b or later, I'd recommend using DATASTORE to manage your import. It automatically breaks up files i...

mehr als 9 Jahre vor | 0

Beantwortet
TEXTSCAN is my personal nemesis: Quotes strings with commas
If you have access to R2016b, try using detectImportOptions with readtable. opts = detectImportOptions(yourfile); T...

mehr als 9 Jahre vor | 1

Beantwortet
.csv Date and Time assigned Data Import
Hi George, If you're using R2016b you can import this directly, but it will take a little bit of configuration The following...

fast 10 Jahre vor | 1

| akzeptiert

Beantwortet
Why does dlmread fail to import my csv files using my matlab 2016b installation when the same code works properly in my 2016a installation?
This sounds like an installation issue. The missing function should be installed with MATLAB. You may want to reinstall MATLAB, ...

fast 10 Jahre vor | 0

| akzeptiert

Mehr laden