10 of your answers have been accepted
Awarded to Lei Hou on 31 Aug 2022
Provide your first answer ever to someone else's question
Awarded to Lei Hou on 27 Aug 2019
Feeds
已回答
How to speed up table merge / concatenation?
Hi Andrea, I'm not sure whether ID in each table is unique (no duplicated value) and whether table_2 and table_3 contain all ID...
How to speed up table merge / concatenation?
Hi Andrea, I'm not sure whether ID in each table is unique (no duplicated value) and whether table_2 and table_3 contain all ID...
1 year 前 | 0
已回答
How can I retrieve data from cdfepoch objects into datetime ?
Hi, Try this data = cdfread('yourfile.cdf', 'DatetimeType', 'datetime');
How can I retrieve data from cdfepoch objects into datetime ?
Hi, Try this data = cdfread('yourfile.cdf', 'DatetimeType', 'datetime');
1 year 前 | 0
已回答
Corresponding data arrangement problem
Hi Peter, You can create timetables from your data and use synchronize to to merge them into one timetable. >> load('plot_tida...
Corresponding data arrangement problem
Hi Peter, You can create timetables from your data and use synchronize to to merge them into one timetable. >> load('plot_tida...
1 year 前 | 0
已回答
Specifying "MergeKeys" for "innerjoin"
Hi, Regarding the output of innerjoin, the key values from left table are the same as that from the right table. So, we only ne...
Specifying "MergeKeys" for "innerjoin"
Hi, Regarding the output of innerjoin, the key values from left table are the same as that from the right table. So, we only ne...
1 year 前 | 1
| 已接受
已回答
plotting data in the table
Hi, Stackedplot is designed to visualize table and timeble. Hoping it is helpful to you. Thanks, Lei
plotting data in the table
Hi, Stackedplot is designed to visualize table and timeble. Hoping it is helpful to you. Thanks, Lei
1 year 前 | 0
已回答
Hi. I have different data types (text and numeric) within the array range that I read from the input table. How can I avoid the error of using table2array and cell2mat?
Hi, Please check whether table2cell meets your need. >> t = readtable('Best NST models(1534002).xlsx'); >> table2cell(t)
Hi. I have different data types (text and numeric) within the array range that I read from the input table. How can I avoid the error of using table2array and cell2mat?
Hi, Please check whether table2cell meets your need. >> t = readtable('Best NST models(1534002).xlsx'); >> table2cell(t)
1 year 前 | 0
已回答
Grouping consectuve datapoints from a table into an array
Hi Youssif, Try the following code to see whether it works for you. The main idea is to use diff to find the group edge, and th...
Grouping consectuve datapoints from a table into an array
Hi Youssif, Try the following code to see whether it works for you. The main idea is to use diff to find the group edge, and th...
1 year 前 | 0
| 已接受
已回答
how to split table with different time values
Hi, Datevec is in discourage use now. You can use retime to group your data and do plot. >> tt = readtimetable('tb.csv') t...
how to split table with different time values
Hi, Datevec is in discourage use now. You can use retime to group your data and do plot. >> tt = readtimetable('tb.csv') t...
1 year 前 | 0
已回答
Can one extract a unit of time from a duration object?
Hi Alexandre, Applying seconds/minutes/... to a duration array returns numeric value >> d1 = seconds(60) d1 = duratio...
Can one extract a unit of time from a duration object?
Hi Alexandre, Applying seconds/minutes/... to a duration array returns numeric value >> d1 = seconds(60) d1 = duratio...
1 year 前 | 0
已回答
How to convert a time series data to txt file?
Hi James, You can use timeseries2timetable to convert your timeseries to a timetable. Then use writetimetable to write your dat...
How to convert a time series data to txt file?
Hi James, You can use timeseries2timetable to convert your timeseries to a timetable. Then use writetimetable to write your dat...
1 year 前 | 1
已回答
How to concatenate 4 columns in one table into one coulomb
Hi, You can you mergevars to merge table variables. >> t = table("Japan_001164_jpg.rf.c02ee7802c701e228f23a4033eb236c2.jpg",38...
How to concatenate 4 columns in one table into one coulomb
Hi, You can you mergevars to merge table variables. >> t = table("Japan_001164_jpg.rf.c02ee7802c701e228f23a4033eb236c2.jpg",38...
1 year 前 | 0
已回答
stack command errors with multiple column variables of different data types
Hi CAM, Your code is trying to stacking {'A1' 'B1' 'C1'} into one variable. Since C1 is text while A1 and B1 are numeric, an er...
stack command errors with multiple column variables of different data types
Hi CAM, Your code is trying to stacking {'A1' 'B1' 'C1'} into one variable. Since C1 is text while A1 and B1 are numeric, an er...
1 year 前 | 0
| 已接受
已回答
Merge multiple tables with three keys
Hi David, I'm not sure whether I understand your problem correctly. Based on my understanding, outerjoin should help you with y...
Merge multiple tables with three keys
Hi David, I'm not sure whether I understand your problem correctly. Based on my understanding, outerjoin should help you with y...
1 year 前 | 0
| 已接受
已回答
Simple interactive plot with variable time axis
Hi Dormant, The function "stackedplot" is designed to plot time series data corresponding to the same time. I guess that functi...
Simple interactive plot with variable time axis
Hi Dormant, The function "stackedplot" is designed to plot time series data corresponding to the same time. I guess that functi...
1 year 前 | 0
已回答
I cannot interrupt the display of a very large table with "more on"
Displaying a large table is slow. I agree with you that Ctrl-C doesn't work. I used head(t) / tail(t) to just display the beginn...
I cannot interrupt the display of a very large table with "more on"
Displaying a large table is slow. I agree with you that Ctrl-C doesn't work. I used head(t) / tail(t) to just display the beginn...
1 year 前 | 0
已回答
Convert some Table Variables from Cell to Double
The funciton 'convertvars' is designed to be a convenient way to type conversion of table variable. Regarding your use case, you...
Convert some Table Variables from Cell to Double
The funciton 'convertvars' is designed to be a convenient way to type conversion of table variable. Regarding your use case, you...
1 year 前 | 1
已回答
Plot time series data
The function 'stackedplot' is designed for plotting time series. >> C = {'2022-08-27T00:00:00.019538' 16065 '2022-08-27T...
Plot time series data
The function 'stackedplot' is designed for plotting time series. >> C = {'2022-08-27T00:00:00.019538' 16065 '2022-08-27T...
1 year 前 | 0
已回答
segment exact time of signal
Hi Farhad, You can also use timetable + timerange indexing to complete your task. >> tt = array2timetable(val','StartTime',dur...
segment exact time of signal
Hi Farhad, You can also use timetable + timerange indexing to complete your task. >> tt = array2timetable(val','StartTime',dur...
2 years 前 | 0
| 已接受
已回答
Determining the hourly time series from 5 minutes and 15 minutes time series data
Hi Manikandan, You can use timetable to store your data, and use retime to resample your data. rainfall = readtable('Rainfall....
Determining the hourly time series from 5 minutes and 15 minutes time series data
Hi Manikandan, You can use timetable to store your data, and use retime to resample your data. rainfall = readtable('Rainfall....
2 years 前 | 0
已回答
(Select all that apply) In which of the following situations would you typically use a categorical array?
Hi Sangat, Typically, categorical is useful when your array is large, contains duplicated values and has finite set of discrete...
(Select all that apply) In which of the following situations would you typically use a categorical array?
Hi Sangat, Typically, categorical is useful when your array is large, contains duplicated values and has finite set of discrete...
2 years 前 | 1
| 已接受
已回答
Filter a timetable (balance a panel data)
Hi Angelavtc, You can use unstack to first unstack the "Id" variable into multiple variables (In your case, into 3 variables). ...
Filter a timetable (balance a panel data)
Hi Angelavtc, You can use unstack to first unstack the "Id" variable into multiple variables (In your case, into 3 variables). ...
3 years 前 | 0
| 已接受
已回答
Join several timetables with different variables and times and duplicates
Hi, I came up with two solutions. Solution 1: use outerjoint. It is easy to understand but have duplicated rows that need to b...
Join several timetables with different variables and times and duplicates
Hi, I came up with two solutions. Solution 1: use outerjoint. It is easy to understand but have duplicated rows that need to b...
4 years 前 | 1
| 已接受
已回答
Searching tables, for modification
Hi Frans, To index into a table, you should use T{rows, vars} instead of T(rows, vars). May I ask a question about why didn't ...
Searching tables, for modification
Hi Frans, To index into a table, you should use T{rows, vars} instead of T(rows, vars). May I ask a question about why didn't ...
4 years 前 | 0
| 已接受
已回答
Creating numerical variables from categorical variables in an unbalanced dataset
Hi Grigorios, You can do something as the following. catVar = categorical(["a" "b" "c" "b" "a"]); numValue = [0.1 3 100]; % T...
Creating numerical variables from categorical variables in an unbalanced dataset
Hi Grigorios, You can do something as the following. catVar = categorical(["a" "b" "c" "b" "a"]); numValue = [0.1 3 100]; % T...
4 years 前 | 0
| 已接受
已回答
Plotting table data with dates
Hi Jinang, In your code, the first column of "A" is not a datetime. It is just numeric value calculated by using division opera...
Plotting table data with dates
Hi Jinang, In your code, the first column of "A" is not a datetime. It is just numeric value calculated by using division opera...
4 years 前 | 0
| 已接受
已回答
datetime "PivotYear" doesn't work?
Hi Richard, The pivot year has an effect only when the 'InputFormat' parameter is specified and it includes y or yy. Therefore,...
datetime "PivotYear" doesn't work?
Hi Richard, The pivot year has an effect only when the 'InputFormat' parameter is specified and it includes y or yy. Therefore,...
4 years 前 | 0
| 已接受
已回答
Find a substring in table
Hi Katharina, You should cellstr to convert the categorical data to a cell array of character vectors as: startsWith(cellstr(t...
Find a substring in table
Hi Katharina, You should cellstr to convert the categorical data to a cell array of character vectors as: startsWith(cellstr(t...
4 years 前 | 0
已回答
making `errorbar` work with `datetime`
Sai is correct that errorbar doesn't yet support datetimes. I've made an enhancement request, and hopefully errorbar will be upd...
making `errorbar` work with `datetime`
Sai is correct that errorbar doesn't yet support datetimes. I've made an enhancement request, and hopefully errorbar will be upd...
4 years 前 | 4
已回答
Find a substring in table
Hi Katharina, You can make use of table indexing to get that data you want. I’ll use a simple example below to illustrate the o...
Find a substring in table
Hi Katharina, You can make use of table indexing to get that data you want. I’ll use a simple example below to illustrate the o...
4 years 前 | 2
已回答
Retime timetable out of bounds
Hi Rub, First, about your code examples I have some suggestions. I saw you used datenum in your first post. It is good that you...
Retime timetable out of bounds
Hi Rub, First, about your code examples I have some suggestions. I saw you used datenum in your first post. It is good that you...
4 years 前 | 1
| 已接受
您也可以从以下列表中选择网站：
美洲
- América Latina (Español)
- Canada (English)
- United States (English)
欧洲
- Belgium (English)
- Denmark (English)
- Deutschland (Deutsch)
- España (Español)
- Finland (English)
- France (Français)
- Ireland (English)
- Italia (Italiano)
- Luxembourg (English)
- Netherlands (English)
- Norway (English)
- Österreich (Deutsch)
- Portugal (English)
- Sweden (English)
- Switzerland
- United Kingdom (English)
亚太
- Australia (English)
- India (English)
- New Zealand (English)
- 中国
- 日本Japanese (日本語)
- 한국Korean (한국어)