提问

how to merge multiple csv files (or xlsx files)
Hi, I have here, for example two csv files need to merge(merge into one). Can anyone kindly help how to merge them. Many than...

8 years 前 | 1 个回答 | 0

1

个回答

提问

How to reset the index in the increasing order
Hi, I have the below table by time (old to latest), the first column is the index, but it resets some time. So, I want to add...

8 years 前 | 1 个回答 | 0

1

个回答

提问

Remove part of name from left and right
I have the following table, and I want delete whatever it may be p to first "."(dot) or first "_"(underline), and also remove "_...

8 years 前 | 1 个回答 | 0

1

个回答

提问

How to find the index of the line to find the occurrence of perticular character
Hi I have multiple text files, and am reading. But I want to find the number lines in a text files(s), and also find the occu...

8 years 前 | 1 个回答 | 0

1

个回答

提问

How to extract matching ranks
I have matrix A &B. I want to find rank of elements in B based on matrix A. For example B(1,1)=100. So, it falls in the range of...

9 years 前 | 1 个回答 | 0

1

个回答

提问

How to count the each pair of sequence apeared
Hi, I have below array (of three columns).I want to count how many times B appeared after A (or B) or A appeared after B (or A)...

9 years 前 | 1 个回答 | 0

1

个回答

提问

Read multiple text files and store data
Hi, I want to read Multiple text files and store the data. I used the following code (I attached two text files,the number of...

9 years 前 | 1 个回答 | 0

1

个回答

提问

How to read particular data from text files
I have text file(s). I some how can be able to read them using fid & fopen. After reading, I want to store the data of two types...

9 years 前 | 0 个回答 | 0

0

个回答

提问

How to store particular data
I used the attached code to read the text files, But Now I want to store the particular data: 1. Information after "Additional ...

9 years 前 | 0 个回答 | 0

0

个回答

提问

How to plot certain points (or select data of specified range)
Hi, I want to plot the below data, but only between -10~+10. The raw data is always >-10 to >10. But I only need to plot betwee...

9 years 前 | 1 个回答 | 0

1

个回答

提问

How to get the array elements indexes
Hello Sir/Mada, I have matrix: A=[2 9 0 3] and I want to get Index_A=[1 2 3 4] I used "find" I got the answer (wh...

9 years 前 | 1 个回答 | 0

1

个回答

提问

How to read required information from particular line
Hi, I want to read from particular line as follows: From the text file I want to read after the below line: Additional ...

9 years 前 | 1 个回答 | 0

1

个回答

提问

How to get most similar row in matrix A to matrix B
Sir,I have two matrix A& B. I want to identify and get the most similar row in matrix A comparing to matrix B. I don't bother ne...

9 years 前 | 2 个回答 | 0

2

个回答

提问

How to extract all similar row of matrix A to matrix B
I have matrix A & B, I want to find similar rows in matrix A, to Matrix B. A=[1 2 3;0 1 3;4 8 9;0 1 3] B=[0 1 3] I w...

9 years 前 | 1 个回答 | 0

1

个回答

提问

How to find the most similar row in matrix A to matrix B
I have Two matrix A &B as follows" A=[1.2 2.0 3.3;1.2 2.0 3.2;1.1 2.1 3.3] B=[1.1 2.0 3.2] I want to find most similar ...

9 years 前 | 1 个回答 | 0

1

个回答

提问

How to read the range and corresponding Values
Dear Sirs, I ahve the following table in excel sheet which contains Range, Lower bound, Target,&Upper bound. I want to specif...

9 years 前 | 1 个回答 | 0

1

个回答

提问

Data sorting by time
Dears, I have two tables labeled as Details & Finaldata. I want to rearrange the Details & Finaldata according to the time (a...

9 years 前 | 1 个回答 | 0

1

个回答

提问

Data matching and filter
I have initial set of values are: Initial data: 17 16 12 15 I want to search how many data point...

9 years 前 | 0 个回答 | 0

0

个回答

提问

How to get best fitting and plot multi variable dependancy and regression
Hi, I have Historical data of "Start" and "End". Now, I have "Start" value, but want to predict "End" value. Can some one help m...

9 years 前 | 0 个回答 | 0

0

个回答

提问

how to read csv file containing text and number
Hi, I have CSV files containing mixed data(text & number). [num_data text_data] = xlsread('filename.csv'); but I am g...

9 years 前 | 1 个回答 | 2

1

个回答

提问

How to remove outliers before prediction
Dears, I want to predict current End value based current Start values using previous historical data as I have shown below. I a...

9 years 前 | 1 个回答 | 0

1

个回答

提问

How to find mean&stdev of different unique IDs in given table
Hi, I want to calculate mean and stdv of the below table based on column1 (the column1 data may vary) Now, I have the foll...

9 years 前 | 1 个回答 | 0

1

个回答

提问

Matching string, and update the table
Hi, I want the "Final resulting table". I have Country and names, and NameDataList (names and data). I want add country names...

9 years 前 | 0 个回答 | 0

0

个回答

提问

How to find matching string and re-arrange the table
Hi, I want the "Final resulting table". I have Country and names, and NameDataList (names and data). I want add country names...

9 years 前 | 1 个回答 | 0

1

个回答

提问

How to re-arrange data and find mean of alike entries
Hi, I have data library (RecipeandHTDList) and main sheet contains RecipeList and the numeric data. I want to re-arrange the ...

9 years 前 | 0 个回答 | 0

0

个回答

提问

How to sort by date
I have two data in two matrix (Matrix A: my Table1, MatrixB is my Table 2) as below. But the data is not in the order of date, a...

9 years 前 | 2 个回答 | 0

2

个回答

提问

Prediction based on previous historical data
Hi, I have Historical data of "Start" and "End". Now, I have "Start" value, but want to predict "End" value. Can some one help ...

9 years 前 | 3 个回答 | 0

3

个回答

提问

How to remove outliers & perform Ptest
Hello, I have data as in attachment. I want to calculate Maximum, minimum, Range, Mean, and Standard deviation. But to calcul...

9 years 前 | 0 个回答 | 0

0

个回答

提问

Multi level sorting and filtering
Dears, I have original data in Table1 and want to do multilevel sorting and filtering to remove repeated data and finally get...

9 years 前 | 1 个回答 | 0

1

个回答

提问

How to get minimum element of matrix and corresponding row elements
Hello Dears, I have matrix A of 3X10 as below: A=[0.250 1.000 0.111 0.040 16.000 4.000 0.360 1.563 0.111 0.563 0....

9 years 前 | 1 个回答 | 0

1

个回答