locating a cell from two inputs
显示 更早的评论
if (Variable1 == 'B')
Variable3 = input('Please enter a date after 22/01/2020 in the format dd-mm-yyyy\n');
Variable4 = input('Please select a location to be analysed: China, UK, South Korea, Spain, Italy, USA\n ');
if (Variable4 == 'China')
readcell('dailytotal.csv', 'Variable3', 'China')
end
What would be the code required to take a user input of a date and a country and have it output the value from a table the corresponds to these two inputs?
I have the data in matlab as both a table and individual column vectors if that makes a difference.
I've included my attempt (it continues for the rest of the countries.)
I'm getting the error 'Unkown parameter 'Variable3'
Thanks
2 个评论
Ameer Hamza
2020-5-9
Can you share the format of your table? In what format the date and country values are shored?
Lauren Hough
2020-5-9
采纳的回答
Star Strider
2020-5-9
I see that you found the file and were able to open it!
Try something like this:
dailytotal = array2table(rand(5,3), 'VariableNames',{'Date','China','UK'});
Choose = listdlg('PromptString',{'Select a Country'}, 'ListString',dailytotal.Properties.VariableNames(2:end));
Country = dailytotal{:,Choose+1};
That makes referencing a particular column straightforward. (Use your own ‘dailytotal.csv’ file instead of my synthetic one that I used to test my code.)
2 个评论
Lauren Hough
2020-5-9
Star Strider
2020-5-9
As always, my pleasure! I very much appreciate your compliment!
Sure!
The first assignment creates the ‘dailytotal’ table to test the code.
The second assignment uses the listdlg function to create a GUI list that allows the user to choose one or more countries. (Limit this to one if you wish. (See the example in Present Current Folder Files for Single Selection to set that.) The 'ListString' cell array uses all but the first element of the 'VariableNames' property of ‘dailytotal’ to create the list (so it updates automatically for diifferent tables with the same essential structure, that is with ‘Date’ in the first column).
The third assignment references the appropriate column in ‘dailytotal’. The offset is necessary because the first (‘Date’) column is not included in the list.
After that, you can proceed to do the analyses on the selected country column.
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Other Formats 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
