selecting columns from table

hello, i want to create an application which reads the given table and allows user to select columns and then recreating a table with the selected columns.
I am working on forecasting electricity prices and getting data from https://www.epias.com.tr/en/ my code is working on a fixed table template and that is date-hour-price. But some excel files have more than one currency and the table can be date-hour-turkish lira-usd-cad. i want user to be able to choose currency and work on it. reads table and user selects columns (date-hour-try/usd/cad) and creates new table consisted selected columns. My code is https://pastebin.com/UpSYsQrQ. Reading table and formatting is done but. selection callback and confirm push button callbacks are not working properly. it creates a table but table is irrelevant. it's like i can't keep the read data and create an empty one.

답변 (2개)

Manas Meena
Manas Meena 2021년 5월 31일

1 개 추천

If you want to pull columns from an existing table and create a new table you can use subscripting.
For example you have a table with 10 columns and you want to pull column 1,2,4 and 9 then you can just use
NumericValueTable(:,[1 2 4 9])
Shiraz
Shiraz 2025년 4월 20일

0 개 추천

I have a CSV file where there are 8 coloums and 447512 rows. I want to only select row 3 to plot a graph based on it. How do I do this?. Thanks

댓글 수: 1

filename = 'AppropriateName.csv';
opt = detectImportOptions(filename);
opt.Datalines = 3;
T = readmatrix(filename, opt);
plot(T)

댓글을 달려면 로그인하십시오.

카테고리

도움말 센터File Exchange에서 Tables에 대해 자세히 알아보기

질문:

2021년 5월 28일

댓글:

2025년 4월 20일

Community Treasure Hunt

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

Start Hunting!

Translated by