How do we have it? that can extract a large amount of data from google maps to make use of or use that information to analyze other works. from the screen that the teacher sees now Let's say we use google maps and search for information, ah , we want to find it. And then we want to extract different data, it's like this, but there's a lot of data. How do we have methods or techniques? To extract a large amount of data from google maps in a very easy way. no more than ten seconds Everything will be pulled out. Before we watch, the teacher wants to share this good knowledge with others too . The teacher would like, ah, we, ourselves first, that Have we already locked our google account yet? On the right part of the body, ah, our screen, it 's ours right. Then let us open, ah, website . Teacher, let's get started. Because some of you may be new here. Maybe I'm not familiar with it yet. Here, I want you to type the word map , ah, like this, map dot google dot com in order to access google maps, ah, and then. He will open a screen like this for us. So we're able to, uh, find the information we need. Let's say today, ah, our problem . Please help me to extract information of all restaurants in Phitsanulok for me. Ah yes, it's similar to this. Wow. We are able to extract the information that is, ah, map, it's the name of the shop, it's ah, the restaurant received. and other very interesting information How can we extract the data into a table like this? Ah, let's continue to see once we have entered google maps. Let us type what we want. For example, a shop in Phitsanulok, ah , like this. Let's say that the teacher has received this kind of problem. that to keep a list of all restaurants in Phitsanulok In the system of google maps , come out. The teacher put this keyword in. Like this. On the upper left side, we can type like this. Ok when we put the keyword in what we want to search. yes We press the magnifying glass search button here. wait a minute The information we need will be Come out on our left. That's all the restaurant information that ah is in Phitsanulok province . It's very interesting information. Many of you may take this information. Let's use it for other benefits. This time, hey, how do you do it? Ah, we're going to get the information of each store into a column that google keeps like this. If we do not know this technique I'm definitely tired. Yes, yes. We know this technique. You can pull it out. Let's continue this time. So what tools do we use? to extract all this information Let us open another one. Come to google dot com and type the word google chrome web store. Type google chrome web store. ah, better remember to type it in full so that we can read it easily. Yes, it's google chrome web store. Press enter , ah, and then we'll go to see, ah, the first keyword. What I found was the first one. Let us click into it. then He will come to ah chrome web store , let us come to the search box in the store. Type instant data scraper ah ah ah like this ah ah this is The teacher will ask to zoom for everyone to see . Ah, type it in. When finished typing, press once, we will find the extension of ah google ah extension All three together It's the first one, instant data scraper , and then, and then, all three of these are tools that are used to extract data from the web or web pages. Different that we find. It 's called doing, or maybe it's called doing. means that it is an action It's the action of extracting information. This time, let's use this one. Because looking at the ratings, ah, out of these three, this one is the best. Let us click here, instant data scraper. Wait a moment. He will come to the extension or extension called instant ata. The logo you see is like a picture, um , right? We may be familiar with it. We will use this software. It's an extension Installation is very easy. Let us click on Add in . Click it. Ah, click done. One window will come up and ask us. If we want to add this instant data scraper or not, select add extension. Ah, wait a moment. Then we can see that there will be a small icon over here that appears on the body, ah, the menu bar at the top. Of the chrome of our web browser, ah, when added, it may disappear. I do not need to be shocked. Let us come to the black jigsaw right here. Click into it once Then let us pin it. Click on the icon, ah, pin here, in order to make the ah extension appear on the menu bar above here . ok now our software is ready ah go back to google maps bar one more time ah ok notice now that what we want here it is ready please And it's a lot too. Ah, if we drag and extract each data, it's very tiring. Ah, let's see how we can use the instant data scraper to deal with it. Uh, the cow's icon. instantly this data scraper has already appeared on the top right side of the screen. Before we start, ah , come out there. The teacher wants us to try. Scroll to see all the information we need first. Here, this postponement is It tells the coordinates that the information we want to take. How much is the quantity? Let's say the teacher has postponed. Well, here's the information that It may be a large enough quantity that the teacher with this dataset right here . It could be as many, how many records, how many tens of records. Let us keep the score down. until we have enough with the amount of information in order to specify the scope to provide Go read that. When everything is ready Then let us press the button ah instant data scraper at the top right here . He's going to read the information for us. It's the area marked in red right here. and as a result of which we keep coming down Found that there are all forty-nine shops or restaurants. Ah, don't forget. as the teacher said If you want more or less, we have to come down a lot. so that they will know of the data to be fetched. If this bounded area is not The area that we want, ah, to act on the data, or to pull? Well, we can press the button. Let's try to press it. Ah, will it be here? Is this area right? If not, we can press the ah button. Or is it a big red frame like this? You will find only three information. We keep pressing to guess. until it covers the area we need Let it be a red box. This is the area that we want. And the data scraper can read about forty-nine records when everything is ready before we start. Ah, I want you to come. Tick the infinite scroll button first. Infinite scroll will be replaced by us, ah, keep our scoreing down. In order to tell the coordinates of the data , ah, the system will do it automatically. When everything is ready We were able to press the button. Wait a moment. Instant data scraper offline. This will pull the data out for us. Well, that 's all right here. It's already extracted the information for us . Well, here it is. It's very interesting information. Ah, this time we need to get all the information. Come out and use it. How can we use it? before we take it out and use it The teacher wants us to try, ah, they call it composing the information in the preliminary first. This example is, ah , they call it a location. The teacher will double click it at the head of the column here. He, uh, acts like a random message for us. Therefore, we have to adapt In a format that we can read and understand easily. Ah, what is this? It's the shop's name, nah . The left side is the location. It's the shop's name. Ah , let's see the next information. what is this This is probably If you look at this, it should be, right? It's a matter of information . As we are interested It's okay Anything you don't care about is released first. Ah, here's the word Thai , restaurant. Ah, probably here. It means here. Ah, ah, type. Ah, okay. Next, ah, open or close? This on and off is ah status ah we choose when you see that this is very useful. And here it should be, uh, see, there's a lot, ah, there's an address , if we don't know the technique, whoa whoa, we have to go and copy the data out of each column . That it might get information, ah, it's random. Take only some edits that we have , and we are easy to understand. Now that we've tweaked the structure of the data to some degree, ah, this time, there are three types of data exports: one, export as a CSV file . Do we like this? Do you want data like this? If you want to export like this, choose a CSV file, depending on the purpose. Second, it's an xlsx file, uh , use a familiar extension, nah, it's used with google, er , sorry, used with microsoft excell. And the third way is to copy all the data. The important thing is to read or be pulled out. Store it in the computer's memory so that, ah, paste it into some software, ah, it depends on the usage. Here, the teacher will try. ah, use the method ah copy all first. Yes, copy all and then ah, press once and the teacher will open another tab. We will try to pull the data into google sheet by typing sheet dot new, sheet dot new and then enter ah. We will try from a simple and easy way to see the picture first. Once we have successfully launched google cheese. Let's see if we are at column A one. If we're at column A one Done. Ah , right mouse click. And then paste it, ah, paste it only, ah, click it, ah, how are you, they will paste it, why? The column is clear say that each column what's your name Many people who are working on data Seeing this, I'm happy now. Ah, and then we come to do it. They call it doing data cleansing again. Which column we don't want, let's say we don't take these three columns. We come to column E. Click on the column header E. Hold down the control Come to the head of column F, still press and hold the control. Come to Column G, still hold down the control. Right mouse click and then delete the selected column. Alright, ah, any columns that are not used can be cut off, ah, let's look at this one, don't take this one, don't take this one, don't take this one , click and hold the control plate, then select, choose, choose, still control . live Right click one more time and delete . will be left only What we want. Ah , right here, I think that everyone is starting to like how to use this information for good use. This is what it is, what is different. Then use it. This time, let's look at another one. ah , look at the other one, this one is ah, come back to our place, are you there ? Let's continue. Ah, just now, the teacher showed the technique of copying all. This time, for those who like microsoft excell, you must choose this one. XLSX. Click one click. They will copy, uh , download it for us. Now it's been saved to our device. It's a file named google parenthesis dot x a. ลเอสเอ็กซ์นะครับ คลิกขวา เอ่อ โทษทีครับ คลิกที่ตัวหัวลูกศรน่ะ แสดงใน นะครับ ก็ มาให้เราเรียบร้อยแล้ว เราลอง นะครับ เพื่อเปิด นี้ดูนะครับ อ่า นะครับ อ่า สักครู่น่ะ อ่า เคลื่อนกันช้า นิดหนึ่งนะครับ โอเค นะครับ ตรงนี้ก็คือได้แล้ว นะครับ ก็ การแก้ไขนะครับ เห็นไหมครับ เราจะเห็นได้ว่า ข้อมูลที่ได้มานั้น ไม่มีความแตกต่างกันเลยนะครับ นะ เราได้ข้อมูลในหัวของคอลัมน์ต่างต่าง ตามที่เราไปเลือกมานะครับ คนที่เล่นตัว excel เนี่ย น่าจะปิ๊งไอเดียแล้วนะครับ ว่าเราจะจัดการข้อมูลอย่างไรนะครับ การจัดการข้อมูลอย่างไรนั้น อาจารย์จะไม่พูดถึงนะ อ่า การดึงข้อมูลเข้ามาตรงนี้สําคัญกว่า แล้วก็ให้เราเห็นประโยชน์ของการใช้ตัว เอ่อ ชื่อว่า instant data scraping นะครับ ที่เอามา ทําประโยชน์ ครับ กับข้อมูลของเราในหลากหลายรูปแบบเลยนะครับ อาจารย์คิดว่ามันเจ๋งมากเลย นะครับ ทําให้เรา เนี่ย เอ่อ ได้ไอเดียในการดึงข้อมูลออกมานะครับ อย่าลืมเลือกพื้นที่ แล้วก็ อ่า ทําการกดสตาร์ทเพื่อดึงข้อมูลได้เลยนะครับ เป็น ไง บ้างครับ หวังว่าตัววิดีโอคลิปนี้น่าจะทําให้เราได้ความรู้ดีดีนะครับ นะ ในการดึงข้อมูลมาใช้งานกับซอฟต์แวร์ของเรานะครับ แล้วก็ มีคําแนะนําอะไรนะครับ อยากให้จารย์ สอนหรืออยาก เอ่อ หรือว่าเจอปัญหาอะไรในการใช้ซอฟต์แวร์นะครับ ไอที around u ช่องนี้ยินดีให้ความช่วยเหลือและแนะนําทุกท่านนะครับ ขอบคุณที่ติดตามนะครับ ฝากกด ด้วยน่ะ แล้วเรามาพบกันในองค์ความรู้ใหม่ ขอบคุณครับ สวัสดีครับ
