File & Data Management
File Handling – The Basics of I/O
Understand how to open, read, write, and manage files in Python. This is essential for tasks like writing flags to a file, reading wordlists, or logging exploits.
Question1.
Which function is used to open a file in Python?
Question2.
What mode allows reading from a file?
Question3.
Which mode overwrites content in a file?
Question4.
How can you check if a file exists before opening it?
Question5.
Which method reads all lines of a file into a list?
Question6.
What error is raised when trying to open a non-existent file in read mode?
Question7.
Which method would you use to move the file cursor?
Question8.
Which keyword ensures files close automatically after use?
CSV & Excel – Taming Tabular Data
Work with structured data formats used in recon reports, leaked credentials, and exported results.
Question1.
Which Python module handles CSV files?
Question2.
Which method writes a single row to a CSV file?
Question3.
Which module reads .xlsx Excel files?
Question4.
What data science library can read both CSV and Excel files?
Question5.
Which pandas function loads a CSV file into memory?
Question6.
Which pandas function writes a DataFrame to a CSV file?
Question7.
Which pandas method writes data to an Excel file?
Question8.
Which method in openpyxl returns all the sheet names in an Excel workbook?