Use PyPDF2 - which PyPDF 2 or PyPDF 3 should be used?

Use PyPDF2 - which PyPDF 2 or PyPDF 3 should be used?

Introduction In previous article, we can extract text on a PDF file using PyPDF2. Use PyPDF2 - open PDF file or encrypted PDF file Use PyPDF2 - extract text data from PDF file I will introduce PyPDF3 in this article. PyPDF2 and PyPDF3 exist When I looked for various usage of PyPDF2, I found the follwing commnet in StackOverflow. The PyPDF2 has been stopped since 3 years ago?! And, new
Use PyPDF2 - extract text data from PDF file

Use PyPDF2 - extract text data from PDF file

Introduction In previous article titled ‘Use PyPDF2 - open PDF file or encrypted PDF file’, I introduced how to read PDF file with PdfFileReader. Extract text data from opened PDF file this time. Preparation Prepare a PDF file for working. Download Executive Order as before. It looks like below. There are three pages in all. Accessing to pages Accessing to arbitrary page The following code describes accessing the specified page
Use PyPDF2 - open PDF file or encrypted PDF file

Use PyPDF2 - open PDF file or encrypted PDF file

Motivation Since I want to work PDF file with Python on my work, I investigate what library can do that and how to use it. Preparation The runtime and module version are as below. python 3.6 PyPDF2 1.26.0 Install PyPDF2 To work PDF file with Python, PyPDF2 is often used. PyPDF2 can Extract text from PDF file Work existing PDF file and create new one Let’s install with pip command.
Use openpyxl -  Convert to DataFrame in Pandas

Use openpyxl - Convert to DataFrame in Pandas

Introduction Previously, I wrote several articles on working Excel files using openpyxl. Use openpyxl - open, save Excel files in Python Use openpyxl - create a new Worksheet, change sheet property in Python Use openpyxl - read and write Cell in Python In this article, I introduce how to convert openpyxl data to Pandas data format called DataFrame. Preparation Install modules First, install module with pip command. 1pip install openpyxl
Use openpyxl - read and write Cell in Python

Use openpyxl - read and write Cell in Python

Introduction In previous article, “Use openpyxl - create a new Worksheet, change sheet property in Python”, I introduced how to create a new Worksheet and change Worksheet properties. In this article I show how to read and write Cell in Excel with Python. Enter values to Cell Worksheet object has a position of Cell as property. That is dictionary type and consists of row and column number. Using them, access
Use openpyxl - create a new Worksheet, change sheet property in Python

Use openpyxl - create a new Worksheet, change sheet property in Python

Introduction In previous article, I showed how to create a new Excel file with openpyxl in Python. In this article, I create a new Worksheet, change sheet property Excel files in Python. Environment Runtime environment is as below. python 3.6 openpyxl 2.5.6 Create a new Worksheet Use create_sheet function to add new Worksheet. 1from openpyxl.workbook import Workbook 2 3wb = Workbook() 4 5ws1 = wb.create_sheet("Sheet_A") 6ws1.title = "Title_A" 7 8ws2
Use openpyxl - open, save Excel files in Python

Use openpyxl - open, save Excel files in Python

Introduction In this article I show how to work Excel with openpyxl. Environment Runtime environment is as below. python 3.6 openpyxl 2.5.6 Install Use openpyxl. The openpyxl official document says .. openpyxl is a Python library to read/write Excel 2010 xlsx/xlsm/xltx/xltm files. However, openpyxl can also work with Mac Excel 2016 on my Macbook Pro. Let’s install with pip command. 1pip install openpyxl Create new Excel file Import openpyxl At
Ansible playbook configuration for MySQL8 (how to change root password etc.)

Ansible playbook configuration for MySQL8 (how to change root password etc.)

MySQL major version 8 was released on April 2018. I introduce how to write MySQL 8 ansible playbook. Motivation I usually use AWS. AWS has a database managed service called RDS, and RDS supports MySQL 5.x series. To conduct in-house training using MySQL 8, I needed to make AMI of MySQL 8 with ansible. Environment CentOS 7 Ansible 2.6.1 Packer 1.1.3 Configuration sample of ansible playbook In this case, I describe only the main task definition part in Ansible, I omit Packer configuration because it becomes redundant.
Install Docker to Amazon Linux2

Install Docker to Amazon Linux2

Migration of Amazon Linux to Amazon Linux 2 causes yum install docker command doesn’t work in Amazon Linux 2, so I investigate how to install docker. Motivation Install Docker to Amazon Linux2 without error My Packer build job stopped with error after AWS announced Amazon Linux 2 LTS Candidate in June 2018, because I migrated my server os Amazon Linux to Amazon Linux2. Fail to execute yum install docker and yum search docker command because yum repository has been changed.

Change Soft/Hard limits and file descriptor limits on Amazon Linux 2(systemd)

Motivation When I migrate Amazon Linux to Amazon Linux2, I investigate how to change file descriptor limits and number of process per user on Linux server working with systemd. This post is technical memo for myself. I try the following procedure after booting the official Amazon Linux 2 AMI as it is. Soft limits and Hard limits Let me review what Soft limits and Hard limits are. Linux limits the number of process per user.