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: Information Technology
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
Build your own email tracker using PHP-MySQL
Sometimes tracking email is useful to know if the recipient received an email and whether they opened the same. There are some free and paid solution is already available in the market. In this post, I am writing to describe the strategy of tracking email using popular technology PHP and MySQL database. Use Cases Email… Continue reading Build your own email tracker using PHP-MySQL
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
Download image from Instagram Post Link
Instagram doesn’t allow you to download an image from the app or its website. Even on the website, you can’t get the image related options in the context menu(right-click): There are few ways to get the image from the Instagram. I am going to describe the easiest way of doing the same. Get the post… Continue reading Download image from Instagram Post Link