 I'm using a spare cell phone to record this video and for some reason the video is very dark even though it's well-letten here, but I don't have time to figure that out. So bear with me. We're going to be looking at the screen here in a moment anyway. So the other day I posted a video about converting JSON to CSV files, sort of comma-separated value files, basically your text files, where you have a delimiter divide up columns so it makes it into a spreadsheet. And someone commented like this. They asked me, one, why I'm, they're surprised that I'm using LibreOffice, which in truth I have LibreOffice installed. I don't really do a lot of office document stuff. I try to use plain text files for everything, whether I'm typing up a document of text or if I'm working with spreadsheets I use CSV files. CSV files are very common if you go to your bank's website or your credit card's website. Lots of times they'll let you download your history and one of the options they'll usually say Excel format and most of the time that's just CSV file, which is just a plain text file that can be opened up in a spreadsheet document. And again, I usually just stick to text files and I'll just view them on my terminal. There was a shell-based viewer for viewing CSV and Excel files and other spreadsheet files that I saw Luke Smith use and I played with that once or twice but never really got into it. Well, this comment from the video the other day, they were surprised I didn't use Visidad, which I had never heard of before. Well, I learned about it about a half an hour ago and I'm doing a video on it. My video is going to be very simple. This program does a lot. Do yourself a favor. YouTube search Visidad and watch the video that's made by one of the creators at a conference. It's a five minute video called Visidad, a lightning demo at Python Cascades 2018. And they go even further into this and in that video, they have a spreadsheet file that has some latitude and longitude in it, a lot of data sets, but two of the columns are latitude and longitude and they actually did a color interactive map in the terminal based on that data plotting it out, which is pretty cool. I haven't got that far into it, but let's pull down some fake data from once again random user dot me. The other day we download this is a JSON converted to CSV. And I don't think I mentioned in that video, they do support CSV. So you can actually dump it straight from that website as a CSV. I was just using it as an example of JSON data. But here we go. I got W get random user dot me API results. I'm going to pull down 20 fake user information and I'm going to format a CSV and I'm going to put it into a file called people dot CSV. I'll do that. We'll just take a second. I also visit that it seems to be very good about determining what type of file this is because I pulled up a tab CSV, a tab separate file. So basically the same thing, but instead of using commas, it uses tabs and but a file was just named dot txt, but it's still recognized that we're tabs in there and divided up the columns accordingly. Anyway, pseudo apt on your Debian based system install. Got a spell install, right? I always when I type fast, get that in an S backwards. Visi data, just like that will install it. I already have it installed. Once it installed, you can type out visit data, but it also seems to have it either aliased or linked as VD, which I just realized is kind of funny. So type VD or visit data and that CSV file that we just created, excuse me, and it looks like this. You know, it's a spreadsheet and you got your columns here and you can scroll through them. You can go down. You can use VIM bindings to move up and down, left and right. Now, if you get to a column and like, let's say I don't care about their login salt, I can just do the minus key. The minus key just hides a column. We're not editing the file at this point. We're just hiding columns at this point, right? So we can do that. Another thing that might be very common is you can filter columns. So first I'm going to go to this first column of gender. I'm going to hit the pipe symbol, and then I'm going to give it what I want to filter it and does partial matches. You can also use regular regular expressions or regexes here. You'll see when I hit pipe down at the bottom, it says select regex. So you can give it regular expressions. I'm just going to type in female. I'll hit enter and it highlights all the rows that that column says female. If I now at this point hit the quotation mark, it hides all the other rows and only shows the ones that say female for gender. If I go over to name title, I can do the same thing. I'll do pipe, I'll do miss, oops, miss. I'll hit enter. It highlights the rows of the matches. If I hit quotation mark, it narrows down that list. I'm going to go to last column, which is the nation that they're in. I'm going to hit pipe. I'll hit GB for Great Britain and I will hit enter. It highlights those. I hit quotation marks and now we have just found in this fake data set all the females that go by miss that are in Great Britain. We just narrowed down the list. And again, in the other video I talked about, they showed you how to plot out very advanced plots to do to visualize mapping data. But real quick, I'm going to scroll over to a column here called DOB, date of birth. And what I'm going to do is I'm just going to hit shift F and it just plotted out, as you can see, a little graph based on the date of birth of what we had narrowed the list down. Now, at any point if I hit, is it escape? No, Q. Q basically brings you back a command. I hit it so many times, I went out of the program. So now I can, now I'm viewing the entire file, the entire 2000 names that we downloaded. Again, fake information here. But we're going to go over again to that date of birth column. And if I hit shift F, I just plotted it out and they list it. There's in this particular data set. People who are 28 make up 50 of those people. That's 2.5 percent. And you can see the chart here and you can sort. And again, I've only been playing with this for maybe a half an hour. And don't you love people who do tutorials on something that they just are doing? But I just thought this was such a great program. I had to do a video on it before I forgot to do a video on it. So maybe I'll do some more advanced stuff in a future video. But I just wanted to bring this to your attention since it was just brought to my attention. And again, the person who does, again, YouTube search, visit at visit data and the or visit data. I'm not really sure. The one of the first videos we get up was called visit data, visit data, lightning demo at Python Cascades. Watch that video. It's a five minute video. And it's a great little demonstration on some of the stuff this program can do. But yeah, doing stuff in the terminal, especially stuff like this, it's just so much cleaner and faster and easier when you have the right tools then going into a GUI application. And I just in a little bit of play with this, I know I'm going to be using this program a lot. So I thought I'd share it with you. Thank you for watching. Check out this program. Check out other videos on YouTube that go more in depth on it and give you some more key bindings for it. At any point, if you hit Backspace in this program, it does bring up the help file. It's kind of like they know that you're going to mess up and your your your default is to hit Backspace. It's like, you need help if you're hitting Backspace. And again, I can hit Q to get out of that, Q to get out of this, Q to get out of that. And again, anything you do, you hit Q to back out of. So yeah, filmsbychrist.com. That's Chris Decay. There's a link in the description. I thank you for watching. I appreciate your support. I do have a Patreon page. There's a link in the description of the video for that. I also have other ways you can support me. PayPal, LibrePay, filmsbychrist.com. That's my website. There's a link in the description. There is a support section that will bring you to all that stuff. Then you can also search through all my videos with nice little thumbnails on my website. If you can't support financially thinking about liking, sharing, subscribing, commenting and interacting with me. I hope that you enjoyed this video. You learned something useful and I hope that you have a great day.