How import file csv with vertical header

2018 7 16
2 个回答
更新时间：2018 7 22
11 次查看（30 天）

0 个投票

I am trying to import file csv. The header of the file is located on the vertical layout. For example, there are table with dimention 9x2, and the header is in column 1.
Name :; A
birth :; 22-Feb-1964
Age :; 1
Height :; 168.8 m
Weight :; 50.0 kg
Address :; C
School :; D
Note :; E
Range of time :; 07-May-14 13:46 - 12-May-14 08:12
Any of you have an idea how to import this csv file, by aware the type of each data (e.g.: double/string/etc)?

请先登录，再回答此问题。

回答（2 个）

0 个投票

Hi Agnes,
One way you could accomplish this is to first convert your data into an array and then transpose it.
a = readtable('YourCSV.csv', 'Delimiter', ';', 'ReadVariableNames', false);
b= table2array(a)'; % convert to array and transpose.
Then you'll need to convert it back to a table and update the variable names.
newTable = array2table(b(2,:));
To update the variables names you can use the command:
newTable.Properties.VariableNames = a{:,1};
BUT... the way the names are currently recorded in the data results in invalid table variable names due to the space and colon at the end.
You could remove those in a loop prior to setting them.

7 个评论
显示 5更早的评论 隐藏 5更早的评论

Agnes Palit
Agnes Palit 2018-7-16
opt = detectImportOptions(/User/file.csv);
T = readtable(direction, opt);
newT = table2array(T(:,:));
newT = newT.';
newT = array2table(newT(:,:));
newT.Properties.VariableNames = {'Project', 'Subject', 'Measurement',...};
output = newT(:,:);
I am using this code, and I think it adapts some of your code as well, but it does not solve the type of the data (e.g.: double/string, etc), do you have idea about this?
What do you want the data types to be?
Agnes Palit
Agnes Palit 2018-7-16
Name :; A
birth :; 22-Feb-1964
Age :; 1
Height :; 168.8 m
Weight :; 50.0 kg
Address :; C
School :; D
Note :; E
Range of time :; 07-May-14 13:46 - 12-May-14 08:12
according this example, there are string, datetime, double. Do you have idea how to adjust the type?
You can use various methods to adjust the type but it depends on the starting type and what you want it to be. Without an example of what you want to do the best I can tell you is to look at:
str2double() and
num2str
Agnes Palit
Agnes Palit 2018-7-16
编辑：Agnes Palit 2018-7-16
Thank you, but I do not think the solution will be as simple as that. As specially to handle the type datetime. That is why I am using "detectImportOptions" to try handle the problem, and put code like this:
opt = setvartype(opt, [4 5], 'datetime');
opt = setvaropts(opt, [4 5], 'InputFormat', 'dd-MMM yyyy', 'DatetimeFormat', 'eee uuuu-MM-dd HH:mm:ss' );
but this code just handle the file from "csv/another as long that is file (but with horisontal header not vertical)", not from "table"
Even we use function "DateTime" it will not solve the problem successfully. But if you have another idea which is more clear, please let me know. Thank you
Christopher Wallace
编辑：Christopher Wallace 2018-7-16
Please give me a specific example of what you're trying to do and all of the code you currently have.
Agnes Palit
Agnes Palit 2018-7-16
编辑：Agnes Palit 2018-7-16
Thank you, for the example data I already mention twice for you (above - that is the data I type manually which is actually put in csv file).
This is the following code:
filedir = '/Users/';
files1 = dir(fullfile(filedir, '*.csv'));
numFiles1 = length(files1);
for i = 1:numFiles1
if (contains(files1(i).name, 'header') == 1)
[header] = header(filedir, files1(i).name);
end
end
this is the function "header.m":
function [output] = header(folder, name)
%UNTITLED Summary of this function goes here
% Detailed explanation goes here
direction = strcat (folder, name);
opt = detectImportOptions(direction);
% opt = setvartype(opt, [2 9], 'datetime');
% opt = setvartype(opt, 4, 'double');
% opt = setvartype(opt, 5, 'double');
% opt = setvaropts(opt, [2 9], 'InputFormat', 'dd-MMM-yyyy', 'DatetimeFormat', 'eee uuuu-MM-dd HH:mm:ss' );
% opt = setvaropts(opt, 4,'Suffixes',' m')
% opt = setvaropts(opt, 5,'Suffixes',' kg')
% T = readtable(direction, opt);
T = readtable(direction, 'ReadVariableNames', false);
% T = T.';
newT = table2array(T(:,:));
newT = newT.';
newT = array2table(newT(:,:));
newT.Properties.VariableNames = {'Name', 'birth', 'age', 'height', 'weight', 'address', 'school', 'note', 'time'};
newT{2,1} = datetime(newT{2,1});
output = newT(:,:);
end

请先登录，再进行评论。

Walter Roberson
Walter Roberson 2018-7-22

0 个投票

It is not possible to use readtable() for this purpose in any useful way, as readtable() expects the columns to be consistent data format, and would probably just give up and say that the second column was all character vectors.
You could perhaps adapt the code I posted in https://www.mathworks.com/matlabcentral/answers/285186-importing-data-without-knowing-number-of-columns#comment_368710 which goes through a bunch of trouble to figure out what the data types are of a cell array

类别

在 帮助中心 和 File Exchange 中查找有关 Variables 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by