Respondida
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)

más de 8 años hace | 5

| aceptada

Respondida
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...

más de 8 años hace | 0

Respondida
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...

más de 8 años hace | 0

Respondida
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...

más de 8 años hace | 1

| aceptada

Respondida
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...

más de 8 años hace | 0

Respondida
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...

más de 8 años hace | 1

Respondida
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...

más de 8 años hace | 0

Respondida
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...

más de 8 años hace | 1

Respondida
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',...

más de 8 años hace | 0

Respondida
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...

casi 9 años hace | 2

| aceptada

Respondida
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 ...

casi 9 años hace | 0

Respondida
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...

casi 9 años hace | 3

| aceptada

Respondida
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...

casi 9 años hace | 0

| aceptada

Respondida
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...

casi 9 años hace | 0

Respondida
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...

casi 9 años hace | 12

| aceptada

Respondida
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...

casi 9 años hace | 1

| aceptada

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

casi 9 años hace | 0

Respondida
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',...

casi 9 años hace | 0

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

casi 9 años hace | 0

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

casi 9 años hace | 0

Respondida
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>. ...

casi 9 años hace | 1

Respondida
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...

casi 9 años hace | 1

| aceptada

Respondida
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...

alrededor de 9 años hace | 0

Respondida
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...

alrededor de 9 años hace | 1

Respondida
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...

alrededor de 9 años hace | 1

Respondida
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...

más de 9 años hace | 1

Respondida
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...

más de 9 años hace | 0

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

más de 9 años hace | 1

Respondida
.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...

más de 9 años hace | 1

| aceptada

Respondida
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, ...

casi 10 años hace | 0

| aceptada

Cargar más