Reading first column of a .csv file
30 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Zack Bayhan
am 29 Aug. 2015
Beantwortet: Sahil Negi
am 18 Okt. 2021
Hi everyone, I'm having some difficulty getting the information I'm looking for extracted. I would like to pull everything from the first column from rows 2 to the end. When I use txtread I extract the entire document, I've tried a few other read functions however they produced errors. Any help would be greatly appreciated, I've attached the .csv file and the script producing the .csv file. Thanks in advanced and hope you all have a great weekend. Zack
fu=['https://raw.githubusercontent.com/datasets/s-and-p-500-companies/master/data/constituents-financials.csv'];
urlwrite(fu,'Symbols.csv')
symbols=textread('symbols.csv','%s');
0 Kommentare
Akzeptierte Antwort
Star Strider
am 30 Aug. 2015
I would use xlsread:
[~,symbols] = xlsread('Symbols.csv', 'A:A');
This imports a (497x1) cell of the symbols in Column A, plus the column header ‘Symbol’, so you may only want to use the last 496.
0 Kommentare
Weitere Antworten (3)
Walter Roberson
am 30 Aug. 2015
fid = fopen('symbols.csv', 'rt');
datacell = textscan(fid, '%[^,]%*[^\n]', 'HeaderLines', 1);
fclose(fid);
symbols = datacell{1};
0 Kommentare
Sahil Negi
am 18 Okt. 2021
You can use importdata as shown below:
symbols = importdata('Symbols.csv');
column_1 = symbols.data(:, 1);
This should get your first column without the header.
0 Kommentare
Siehe auch
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!