Python Pandas Operation Collection

(a panda enjoying his/her time)

I’ve frequently encountered operations that are not well supported by the original pandas package and every time when this happens I have to spend some time looking for clues on StackOverflow . Therefore I decided to make this collection for self-reference and of course for anyone who might find it helpful! (I will keep adding new codes! )

I. Creating a DataFrame

1. From existing files:

Please refer to this link:pandas Input/Output Reference

Input file types supported by Pandas: .csv, .xlsx, .zip, .txt, .json, .xml, .html, images, Hierarchical Data Format, .pdf, .docx, .mp3, .mp4, .sql

2. Creating from a dictionary: