6:43 9:45 a classic problem when making a program like Matlab 11:08 Import/Upload 11:40 Import tool 12:16 13:0713:36 16:3118:03 18:27 19:2219:54 20:14 20:5721:4322:05 23:1023:3324:34 24:44 gen code=save graph template 25:1725:3025:57 *(So far this is just a really long way of doing the same templates you quickly do in Excel* but you have to: 1. Properly format data in Excel (Format it in a new Excel file as XYZ without data above if you have a lot of rows) before importing it because you can't move/edit it, 2. Import/Upload File (Hope it isn't too large or else it doesn't always work, if nothing happens it's too large. Again best you make a new Excel file to import.) And select columns/rows to import selected. 3. then Plot tab it, 4. edit plot format, 5. then File>Generate Code while on the graph, 6. then save the code as another MatLab code file, 7a. (Repeat step 2 AKA) Make a new Excel sheet from your new data, format it, then Upload, open file, select data you want, right-click>import selection. To use any other new data. 7b. then you can type the formula name and your new variable labels (with the properly formatted associated data in the worksheet if the MatLab code file is in your current folder) 26:42 can color using the variable associated with the other properly formated data table. 27:34 read the green text to learn. 28:3729:19 30:29 What to do with blank data from Excel 30:46 You can make a rule to replace with text or to exclude it. 31:43 Generate Function to get code with your rules (Excel must all have the same layout) to import Excel Data. Use to automate step 2. 33:00 _Single Purple Quote means literal text, not a variable_ 32:54 Automation of Step 2. _33:53__ right-click>help on selection for formula explanation_ 34:42 (The fewer rows in this example are due to his rule to exclude empty cells) Can select and plot data in the variable's table. 35:35 I guess tables are good for data (I'm still not sold on this over Excel) _36:41__ Up Arrow, __36:47__ __37:07__ Tab is autocomplete when you start typing, like in Excel._ He did steps 7a and 7b again. 37:50 What you've learned. 38:2338:37 Try to predict data. Test predicted data by predicting data you have. 38:52 Split data using "Logical Indexing", (same type of indexing in Excel) 39:10 Matrix Variable label(Row#,Column#) leads to> "Subscript Indexing" 39:1939:29 Variable label([Row#,Column#],WholeColumn#) leads to> question 39:49 then action Index on a variable range. 40:05 Variable Label (VL) 40:24 "VL=a
Got here because of finding the comparison of excel from matlab. First few minutes of watching I download the file, then few minutes of watching I subscribed to the channel, then few more minutes I click like button and now I commented. Very well said and clear discussing the basic in matlab. You are a more help to teachers like us.
What a superb teacher! A pleasure to listen to, thoroughly professional and what great material he teaches. Brilliant, I learnt more in an hour than the combined tutorials I found on the net over the last 2 weeks. I would love to see more stuff from Adam....Bravo!
This is exactly the video that I needed. I've been working with huge data sets in Excel and my job finally bought me Matlab and I basically just need to know how to make the transition. You've done that and also shown me just how much more powerful of a tool this can be for my needs.
I really wanted him to correct IMport to Import. I was going a little crazy every time his mouse moved towards the word. Really great video - thanks so much.
I feel this video has helped me to become slightly more familiar with MatLab. I have an extensive background in Excel and basically no background in MatLab. When I take a course on MatLab I'll at least have some idea of where some of the basic features are and a few syntax things.
Really Useful video. I hv a doubt : At time 26:55, why he used AvgRelHum variable as input for color code? How does that affects solratio data in Z scale? It looks like representation of relationship between 4 variables in 3D plot.
You are simply the Best! I've never had such an effective programming lesson before in my life. Can I please suggest that you you specify your videos with a very distinct naming system that will make it Just stand out from all other similer youtube lectures. Salute to you! Nkululeko from South Africa.
At time 23.32 i have a found a mistake in x axis because it should be hours in day because day of the year should be at y axis not in x axis according to me please clarify it. Thanks
Well although you knew the model to be fitted, the sse is quite high and adj r square is low. So when I don't have a predefined model, and my adj r square is low for most of the models I try, then how can I predict which model is the best one?
At 21.57 you shows how to colour data in plot according to its Z Value. I tried it in 2020 but the property inspector is not the same as the one you showed. Can you help me in how to colour data in plot based on z value in 2020?
Hi, Trying to change the marker colour according to its z value, but the drop-down menu that you have selected is not there in Matlab 2016b, can you please tell me where it is hiding. can't do it from the more properties as well.
I would do this, except that my Excel file has all the variable names in the first column, not the first row. I tried saving a transposed version of the file that had all the variable names in the first row--and MATLAB did the idiotic thing of transposing my entire file so that once again, the variable names are in the first column. Very frustrating. I think I will stick with Excel for now.
Hi Nice explanation, Numbers version 3.6 (2557) mac spreadsheet. When i import it to Matlab. i am not getting the data rather getting some symbols. Can you help me?
+Nur Shafinaz Yes it can. It depends on how your lidar hardware produces data. ASCII formats can be read using txtread, or fscanf. You may also be able to connect your hardware's output directly to a computer for live streaming. Check the Data Acquisition Toolbox: www.mathworks.com/products/daq/
+Nur Shafinaz Once the data is in, the coding really depends on what you're trying to do. Check out resources on www.mathworks.com to learn more about your use-case.
I have learned more about Matlab in the past 59 minutes than I have in class in the past two semesters. Wow...
lol, indeed true
6:43
9:45 a classic problem when making a program like Matlab
11:08 Import/Upload
11:40 Import tool 12:16
13:07 13:36
16:31 18:03
18:27
19:22 19:54
20:14
20:57 21:43 22:05
23:10 23:33 24:34
24:44 gen code=save graph template
25:17 25:30 25:57 *(So far this is just a really long way of doing the same templates you quickly do in Excel* but you have to:
1. Properly format data in Excel (Format it in a new Excel file as XYZ without data above if you have a lot of rows) before importing it because you can't move/edit it,
2. Import/Upload File (Hope it isn't too large or else it doesn't always work, if nothing happens it's too large. Again best you make a new Excel file to import.) And select columns/rows to import selected.
3. then Plot tab it,
4. edit plot format,
5. then File>Generate Code while on the graph,
6. then save the code as another MatLab code file,
7a. (Repeat step 2 AKA) Make a new Excel sheet from your new data, format it, then Upload, open file, select data you want, right-click>import selection. To use any other new data.
7b. then you can type the formula name and your new variable labels (with the properly formatted associated data in the worksheet if the MatLab code file is in your current folder)
26:42 can color using the variable associated with the other properly formated data table.
27:34 read the green text to learn.
28:37 29:19
30:29 What to do with blank data from Excel 30:46 You can make a rule to replace with text or to exclude it.
31:43 Generate Function to get code with your rules (Excel must all have the same layout) to import Excel Data. Use to automate step 2.
33:00 _Single Purple Quote means literal text, not a variable_
32:54 Automation of Step 2.
_33:53__ right-click>help on selection for formula explanation_
34:42 (The fewer rows in this example are due to his rule to exclude empty cells) Can select and plot data in the variable's table.
35:35 I guess tables are good for data (I'm still not sold on this over Excel)
_36:41__ Up Arrow, __36:47__ __37:07__ Tab is autocomplete when you start typing, like in Excel._
He did steps 7a and 7b again.
37:50 What you've learned.
38:23 38:37 Try to predict data. Test predicted data by predicting data you have.
38:52 Split data using "Logical Indexing", (same type of indexing in Excel)
39:10 Matrix Variable label(Row#,Column#) leads to> "Subscript Indexing" 39:19 39:29 Variable label([Row#,Column#],WholeColumn#) leads to> question 39:49
then action
Index on a variable range. 40:05
Variable Label (VL)
40:24 "VL=a
Thanks for the great work! But I can't find the part where epstein didn't kill himself.
@@christopherneufelt8971 That's at 69:42
Got here because of finding the comparison of excel from matlab. First few minutes of watching I download the file, then few minutes of watching I subscribed to the channel, then few more minutes I click like button and now I commented. Very well said and clear discussing the basic in matlab. You are a more help to teachers like us.
This is one of the best videos I have ever watched. I just hope python would quickly get rid of R so that no one would ever ask me to use R again.
What a superb teacher! A pleasure to listen to, thoroughly professional and what great material he teaches. Brilliant, I learnt more in an hour than the combined tutorials I found on the net over the last 2 weeks. I would love to see more stuff from Adam....Bravo!
I just came across this video. It's very helpful. Thank you. I hope you post more topics like this by this presenter.
Thanks for watching and for the kind words!
You deserve to say "Thanks Kind Man!". Keep sharing your knowledge! I will do because you did!
This is exactly the video that I needed. I've been working with huge data sets in Excel and my job finally bought me Matlab and I basically just need to know how to make the transition. You've done that and also shown me just how much more powerful of a tool this can be for my needs.
I really wanted him to correct IMport to Import. I was going a little crazy every time his mouse moved towards the word.
Really great video - thanks so much.
Great video! I think I could watch it many times and learn new steps as I learn more about MATLAB.
I feel this video has helped me to become slightly more familiar with MatLab.
I have an extensive background in Excel and basically no background in MatLab.
When I take a course on MatLab I'll at least have some idea of where some of the basic features are and a few syntax things.
Really Useful video. I hv a doubt : At time 26:55, why he used AvgRelHum variable as input for color code? How does that affects solratio data in Z scale? It looks like representation of relationship between 4 variables in 3D plot.
I have a same confusion.
You are simply the Best! I've never had such an effective programming lesson before in my life. Can I please suggest that you you specify your videos with a very distinct naming system that will make it Just stand out from all other similer youtube lectures. Salute to you! Nkululeko from South Africa.
Very good teacher, thank you !! it's very nice, :) , in 2022 we use your video, it's very easy that i thought !
Can you please upload the excel data file also, it would be much better to practice on that same file while watching the video
Outstanding introduction to MATLAB, even if you're not coming from EXCEL.
one of the best tutorial, exactly what my students needed. Thanks a lot for this wonderful presentation.
convert spreadsheet date to datenum in import tool is not there
At time 23.32 i have a found a mistake in x axis because it should be hours in day because day of the year should be at y axis not in x axis according to me please clarify it.
Thanks
Is it possible that I can get the data that you used so I can practice with it?
Well although you knew the model to be fitted, the sse is quite high and adj r square is low.
So when I don't have a predefined model, and my adj r square is low for most of the models I try, then how can I predict which model is the best one?
My "Import Selection" does not have the option to choose "Generate Function", how do I get this? Cannot find it anywhere...
please you can help me to solve nonlinear equation
Outstanding tutorial. Thank you.
Great tutorial. Hoping for more in-depth tutorial on other tools such as Neural Network.
this is amazing, how did it take me this long to use this tool.
how to show two simulations in two different axes but in one gui?
I have data according to time. So I have voltage, power and current and their times. How do i plot that?
At 21.57 you shows how to colour data in plot according to its Z Value. I tried it in 2020 but the property inspector is not the same as the one you showed. Can you help me in how to colour data in plot based on z value in 2020?
Amazingly helpful video. Thanks a lot.
What exactly is the formula for solar ratio?
I am having my energy consumption data in csv format 1440 time stamps. For each day individual file is created how can I make it as single file
My graph is not getting smooth curve
Hi, Trying to change the marker colour according to its z value, but the drop-down menu that you have selected is not there in Matlab 2016b, can you please tell me where it is hiding. can't do it from the more properties as well.
I would do this, except that my Excel file has all the variable names in the first column, not the first row. I tried saving a transposed version of the file that had all the variable names in the first row--and MATLAB did the idiotic thing of transposing my entire file so that once again, the variable names are in the first column. Very frustrating. I think I will stick with Excel for now.
Very clear explanation!! Thanks for the perfect introduction to matlab..
in desperate need of help with making a model if anyone could help that would be great
I never knew matlab is so easy to use !
Hi Nice explanation, Numbers version 3.6 (2557) mac spreadsheet. When i import it to Matlab. i am not getting the data rather getting some symbols. Can you help me?
wow seems like a killer program! So useful
A wonderful introduction
And if some data is missing in the row
Is there an option download the same data in this video for practice?
Can you share the excel file?. Thanks
thank you. very good lesson.
great video to begginers on matlab
What a beautiful explanation!
Very dense, informative video!
how about lidar data. can matlab read it? how?
+Nur Shafinaz Yes it can. It depends on how your lidar hardware produces data. ASCII formats can be read using txtread, or fscanf. You may also be able to connect your hardware's output directly to a computer for live streaming. Check the Data Acquisition Toolbox: www.mathworks.com/products/daq/
+Chetan Rawal I have .las data that need to be input to matlab and do some processing. What about the coding for las data types?
+Nur Shafinaz Once the data is in, the coding really depends on what you're trying to do. Check out resources on www.mathworks.com to learn more about your use-case.
+Chetan Rawal thank you for your response. Really appreciate.
Can you share the excel file, please!!
Just google "Beyond Excel: Enhancing Your Data Analysis with MATLAB" and download "Example Code" on the Matlab page.
@@CheerDesigns Hi, I googled it but I got a different file from the website. Can you share the website?
Excellent presentation. Thanks a lot.
Thank you for sharing knowledge....
Many thanks
Thanks a lot..!
permossion to learn sir
Really amazing , thanks so much
activate subtitles, tks
great 59 minutes tutorial
Very useful video..
great intro video
Thank youuuu!!!
Thank you :-)
omg.. I had no idea matlab was this cool
Great video thx
Thank you very much
manca il traduttore in automatico
I thought you were sal khan for a minute there
Great
3blue1brown?
super
不错。nice