1 00:00:05,830 --> 00:00:06,210 Here. 2 00:00:06,250 --> 00:00:10,680 Even so in this video I will tell you that how you can update the data by using programming. 3 00:00:10,800 --> 00:00:17,470 So that is again very simple just like the other methods copy this one and define a new function here. 4 00:00:17,850 --> 00:00:23,070 So by this way you can define all the methods sale in functions and then just call the function and 5 00:00:23,070 --> 00:00:24,890 make you a vector. 6 00:00:25,020 --> 00:00:36,260 So this an update Bosnian a name Mark and a number of dedicated video so just replace this one with 7 00:00:36,260 --> 00:00:39,560 a simple English comma that is update data. 8 00:00:40,700 --> 00:00:42,820 So we'll just update dataset. 9 00:00:43,060 --> 00:00:43,980 There we have this. 10 00:00:44,570 --> 00:00:46,400 And now what do you want to update. 11 00:00:46,400 --> 00:00:48,260 Simply pass that thing. 12 00:00:48,290 --> 00:00:52,940 So like I want to update the name with a question mark. 13 00:00:53,870 --> 00:00:56,950 And this is something like you need to take one column as a base. 14 00:00:57,050 --> 00:00:57,950 Like I'm digging. 15 00:00:57,950 --> 00:01:02,170 Rule number then I am need to update name and marks. 16 00:01:02,210 --> 00:01:10,200 So just names equal to question Mark Marks equal to again question mark. 17 00:01:10,220 --> 00:01:10,960 Did he had this one. 18 00:01:12,140 --> 00:01:17,850 So where roll number equal to. 19 00:01:17,870 --> 00:01:24,400 Again question mark and the quotes provide a comma there and. 20 00:01:25,130 --> 00:01:28,240 Name Mark. 21 00:01:28,260 --> 00:01:30,840 Rule number informal four troops. 22 00:01:31,340 --> 00:01:32,200 There we go with that one. 23 00:01:33,410 --> 00:01:39,320 So here we have updated the updated the dataset with name is equal to new item with name marks with 24 00:01:39,320 --> 00:01:42,260 Mark weird rule number is of a base. 25 00:01:42,290 --> 00:01:44,610 So let's try this one. 26 00:01:44,750 --> 00:01:49,810 So just update and pass data. 27 00:01:50,210 --> 00:01:53,430 Anything say in that one we have limbo. 28 00:01:53,450 --> 00:01:57,730 First we need to view that one to get to idea what we had then 29 00:02:01,040 --> 00:02:01,950 save. 30 00:02:01,970 --> 00:02:07,820 And we have the terminal there we go for entry. 31 00:02:07,820 --> 00:02:09,560 So let's just change the fort 32 00:02:14,050 --> 00:02:15,080 with say. 33 00:02:15,080 --> 00:02:16,720 Rule number is therefore we have. 34 00:02:17,090 --> 00:02:21,500 So first name from bugger to say super 35 00:02:24,670 --> 00:02:27,970 and then Mark's say 56. 36 00:02:28,310 --> 00:02:30,940 So something notice women and the lower number there. 37 00:02:31,030 --> 00:02:31,900 It is fourth. 38 00:02:32,290 --> 00:02:34,760 So save run. 39 00:02:34,780 --> 00:02:36,420 There we go with that one successful. 40 00:02:37,270 --> 00:02:47,110 Now if the print that one so print will save and run again. 41 00:02:47,110 --> 00:02:49,990 There we go the deadline for super 56. 42 00:02:49,990 --> 00:02:55,710 So this one is updated from bugger to super with the default database. 43 00:02:55,710 --> 00:02:57,640 And now let me move to Denver. 44 00:02:57,880 --> 00:03:00,480 So for that just copy this one. 45 00:03:00,580 --> 00:03:00,970 Come on. 46 00:03:00,970 --> 00:03:04,280 See and base to tail. 47 00:03:04,280 --> 00:03:04,960 Come on. 48 00:03:05,940 --> 00:03:14,150 No I have just added one more drill there so that we can have more data. 49 00:03:14,150 --> 00:03:20,080 If you find that one we will have this one three with a random name and a random marks. 50 00:03:20,120 --> 00:03:28,230 So we are going to do that one for it first just tease the connection we have the sun. 51 00:03:28,530 --> 00:03:34,010 After that remove the commas and replace with percentages maybe go. 52 00:03:34,100 --> 00:03:35,860 There we go. 53 00:03:35,880 --> 00:03:39,700 The last one Navy had save this one. 54 00:03:40,820 --> 00:03:44,480 Now if you just run this one with an update 55 00:03:50,630 --> 00:03:52,610 so here pass update. 56 00:03:52,880 --> 00:03:55,280 Let me have some more space there. 57 00:03:55,280 --> 00:03:55,880 There we go. 58 00:03:56,690 --> 00:04:00,010 So just update and pass there. 59 00:04:00,110 --> 00:04:04,960 According to that one first name say we are going to pass here. 60 00:04:06,140 --> 00:04:08,830 So Burgin so pretty. 61 00:04:08,990 --> 00:04:13,690 And then the earmarks will be say 22 and the roll number. 62 00:04:13,690 --> 00:04:14,610 There it is. 63 00:04:14,610 --> 00:04:21,830 Three save this one run it here lady over deadpan successful. 64 00:04:22,120 --> 00:04:31,460 Now just print view say this one and run it here. 65 00:04:31,480 --> 00:04:33,040 David only three. 66 00:04:33,120 --> 00:04:34,190 So pretty 22. 67 00:04:34,230 --> 00:04:35,970 This is now rated him. 68 00:04:36,480 --> 00:04:38,090 So this is all about the databases. 69 00:04:38,100 --> 00:04:41,870 Now how you can insert data or delete data update data from there. 70 00:04:42,810 --> 00:04:46,910 Now we are done with the database in the next module we will learn about the total graphics. 71 00:04:46,920 --> 00:04:50,560 That is the favorite subject of mine in Python. 72 00:04:50,670 --> 00:04:56,220 And you're also going to like that one because in that one we are going to actually build application 73 00:04:56,220 --> 00:05:00,690 like creating a robot and that move on your particular screen. 74 00:05:00,750 --> 00:05:07,030 So that is us all under the graphical designing and what you will learn about that in the next model. 75 00:05:07,140 --> 00:05:08,360 So thanks for watching. 76 00:05:08,430 --> 00:05:08,990 Sue them.