Load very large file in the MySQL database table using mysql in built bulk load utility and python and using a very local computer. I am using 8 GB of RAM and 4 core domestic processor. Step 1: Install required libraries:Python library required: mysql-connector-python Step 2: Setting the variables: Note: I am using IMDB dataset… Continue reading Load huge or large files into MySQL database
Category: Python3
PDF manipulation with Python: Part 1
Under the hood If you are a coder and comfortable with python, there are many libraries by which you can manipulate PDF file as your own wish. Here are some list of python library which can be used to create or edit PDF files: PDFMiner – This tool is to extract text data from a… Continue reading PDF manipulation with Python: Part 1
Scraping YouTube with BeautifulSoup and Python3
There are few ready made YouTube video download library present in python already. “youtube-dl” is one of them which is very convenient to use. It also has command line interface (CLI) to download video from YouTube hence you do not need to use python code to download video. This article is for some more details.… Continue reading Scraping YouTube with BeautifulSoup and Python3
Some cool yet advance and hidden features of Python
Python has really some great features which make some tasks easier to write from the coding perspective. Sometimes these features called as hidden features as these are either very unique to Python or not very well known. For…Else loop Comparison operator chaining Slicing/Extended slicing Multiple Assignment Value Swapping Argument unpacking / Star operator Yield Statement… Continue reading Some cool yet advance and hidden features of Python