Réponse apportée
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)

environ 8 ans il y a | 5

| A accepté

Réponse apportée
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...

environ 8 ans il y a | 0

Réponse apportée
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...

environ 8 ans il y a | 0

Réponse apportée
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...

environ 8 ans il y a | 1

| A accepté

Réponse apportée
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...

environ 8 ans il y a | 0

Réponse apportée
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...

environ 8 ans il y a | 1

Réponse apportée
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...

environ 8 ans il y a | 0

Réponse apportée
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...

environ 8 ans il y a | 1

Réponse apportée
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',...

plus de 8 ans il y a | 0

Réponse apportée
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...

plus de 8 ans il y a | 2

| A accepté

Réponse apportée
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 ...

plus de 8 ans il y a | 0

Réponse apportée
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...

plus de 8 ans il y a | 3

| A accepté

Réponse apportée
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...

plus de 8 ans il y a | 0

| A accepté

Réponse apportée
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...

plus de 8 ans il y a | 0

Réponse apportée
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...

plus de 8 ans il y a | 12

| A accepté

Réponse apportée
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...

plus de 8 ans il y a | 1

| A accepté

Réponse apportée
string inside a table
Try: >> T = readtable(filename,'TreatAsEmpty',{'-'}) Jeremy

plus de 8 ans il y a | 0

Réponse apportée
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',...

plus de 8 ans il y a | 0

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

plus de 8 ans il y a | 0

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

plus de 8 ans il y a | 0

Réponse apportée
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>. ...

plus de 8 ans il y a | 1

Réponse apportée
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...

plus de 8 ans il y a | 1

| A accepté

Réponse apportée
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...

plus de 8 ans il y a | 0

Réponse apportée
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...

presque 9 ans il y a | 1

Réponse apportée
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...

presque 9 ans il y a | 1

Réponse apportée
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...

presque 9 ans il y a | 1

Réponse apportée
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...

environ 9 ans il y a | 0

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

environ 9 ans il y a | 1

Réponse apportée
.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...

plus de 9 ans il y a | 1

| A accepté

Réponse apportée
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, ...

plus de 9 ans il y a | 0

| A accepté

Charger plus