Filtering excel data!
11 次查看(过去 30 天)
显示 更早的评论
Hello!
I have a large excel file (A1:E14920) that contains data from covid cases from every state from January to November. I need my code to promt the user to pick state (In coloumn B) and create a plot with the dates (column A) and # of Deaths (column E). Anyone know how I can do this? Thank you!
0 个评论
回答(1 个)
Cris LaPierre
2020-12-4
编辑:Cris LaPierre
2020-12-4
I would suggest using logical indexing (Ch 12 MATLAB Onramp) to select the dates and #Deaths that match the user selection. From there, just plot the corresponding data (Ch 9 MATLAB Onramp). If your dates are imported as datetimes, they will appear as your xticks automaticaly. I'd import the file using readtable (see more here).
Personally, I'd use a live script with a drop-down list (see Interactive Controls) to select the state.
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 MATLAB Compiler SDK 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!