Thank you for bringing this to my attention! I've fixed the link to the repo. I'll post the link here as well. The dataset for this video is large so you will have to download that directly from the source. The link should be on the readme. Thank you! github.com/Data-Craftsman-Learn/Pandas-Functions
Hello thx for this video !!! But how can I parse all the records for each rows ? and then the result will be in one table I would like to have it in one DataFrame instead many different data frames =) I mean will have all levels values in one table, like matrix u know... if I have so many levels (~10+) data.key data.doc_count data.1.buckets data.2.values.50.0 0 name1 1992 [{'key_as_string': '2024-01-19T00:00:00.000+02... 98.268412 1 name2 2209 [{'key_as_string': '2024-01-19T00:00:00.000+02... 99.674954 2 name3 2282 [{'key_as_string': '2024-01-19T00:00:00.000+02... 99.909242 3 name4 2294 [{'key_as_string': '2024-01-19T00:00:00.000+02... 100.000000
Hi Aditya, thank you for taking the time to comment on the video. It is a little bit more of an advanced concept. I personally could have made the video simpler, but if anyone at the beginner level has questions, I’m happy to answer.
I have a tab separated csv file. When I import it to pandas, the column headers are off by one. The first column headers is empty, and the second column has the first co header name, the 3rd col has the second col header name. What should I do about that?
Hard to know the exact issue without seeing what the file looks like, but it sounds like there is an extra comma on the first line of the csv. For example: ,col1,col2 Removing the comma should fix the issue in this case.
The Regex function returns a list of strings from the larger body of text. To return it without brackets you would just put the position of the phone number you want to return. For example, if you type phone_numbers[0], it would return the first phone number as a string.
Great explanation! THANK YOU! I'm not searching the installation guide for a screen recording telling me "Just use the default setting" and explaining nothing.
Thanks for taking the time to explain what each section involved. One thing of note is because I downloaded Note++ when Git had already downloaded I had to manually search for the EXE. in program files to use it as my default text editor. Cheers
Thank you. Btw, does sqlite studio have formatting option? Cause in sqlite browser doesn't allow formatting table cell window (above the table, y'know) even though formatting feature exists there overall. Sucks.
Great video. To review LoaderDataPlus tool. This tool import flat files and export to SQLITE syntax and other DMBS. Download this tool from tutorial videos on RU-vid.