6. Python 101 - Files - Skeleton.ipynb

{"nbformat":4,"nbformat_minor":0,"metadata":{"colab":{"name":"6. Python 101 - Files - Skeleton.ipynb","provenance":[],"collapsed_sections":[]},"kernelspec":{"name":"python3","display_name":"Python 3"}},"cells":[{"cell_type":"markdown","metadata":{"id":"iLfi8gKMoAd6","colab_type":"text"},"source":["# 1. TEXT FILES"]},{"cell_type":"markdown","metadata":{"id":"r2IjrNQmoFxC","colab_type":"text"},"source":["- open() is the key function to handle files \n","- open() function takes two parameters: (1) filename (2) mode.\n","- Modes for files opening: \n","\n","    - \"r\" - Read - Default value. Opens a file for reading, error if the file does not exist\n","    - \"a\" - Append - Opens a file for appending, creates the file if it does not exist\n","    - \"w\" - Write - Opens a file for writing, creates the file if it does not exist\n","    - \"x\" - Create - Creates the specified file, returns an error if the file exists\n","\n","- files can be used in a binary or text mode\n","\n","    - \"t\" - Text - Default value. Text mode\n","    - \"b\" - Binary - Binary mode (e.g. images)"]},{"cell_type":"code","metadata":{"id":"xEbqa95ArXlE","colab_type":"code","colab":{}},"source":["# In order to access data on Google Drive, you need to mount the drive to access it's content\n"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"zqk6rO37oC_g","colab_type":"code","colab":{}},"source":["# Open and read text file\n"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"m1596TUCoInJ","colab_type":"code","colab":{}},"source":["# readline will be used to read the first line\n"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"-2Y52n0UoIpX","colab_type":"code","colab":{}},"source":["# You can open the file and append content to it\n"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"6twyC3vfoIrU","colab_type":"code","colab":{}},"source":["# close the file and let's check its content\n"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"sEQ6zDLaoOga","colab_type":"code","colab":{}},"source":["# Let's open the updated file after writing new content to it\n"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"HqnHR33noOiZ","colab_type":"code","colab":{}},"source":[""],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"GJAfep33oOke","colab_type":"code","colab":{}},"source":["# split into a list of words\n","\n"],"execution_count":null,"outputs":[]},{"cell_type":"markdown","metadata":{"id":"_9ihcna1v0Y9","colab_type":"text"},"source":["**MINI CHALLENGE #1:**\n","- **Read the file 'fruits_input.txt'**\n","- **compare the text file content to the list my_fruits = [\"Apple\", \"Pepper\", \"Orange\", \"Watermelon\", \"Tomatoes\"]**\n"]},{"cell_type":"code","metadata":{"id":"FwqzbVBhx5Se","colab_type":"code","colab":{}},"source":[""],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"iL0yRBfyMD6F","colab_type":"code","colab":{}},"source":[""],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"ZMZDbtbGMD8k","colab_type":"code","colab":{}},"source":[""],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"GSIATnQxMyFR","colab_type":"code","colab":{}},"source":[""],"execution_count":null,"outputs":[]},{"cell_type":"markdown","metadata":{"id":"mVEBiOmtnCp4","colab_type":"text"},"source":["# 2. CSV FILES"]},{"cell_type":"code","metadata":{"id":"C6-0bqrqmZS-","colab_type":"code","colab":{}},"source":["# you can read csv files using \"csv.reader\"\n","\n"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"JlyWKV6fmng9","colab_type":"code","colab":{}},"source":["# Let's view the data\n"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"SuYdDHQpnZxL","colab_type":"code","colab":{}},"source":["# Let's view the first row\n"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"iPiq2lkMnbjW","colab_type":"code","colab":{}},"source":["# Let's view the second row\n"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"1EbBeptqm1XY","colab_type":"code","colab":{}},"source":["# Combine first and last names together to generate full_name\n"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"gD3H86PLm3FO","colab_type":"code","colab":{}},"source":[""],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"cjLRTZfcm5_I","colab_type":"code","colab":{}},"source":[""],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"wTXefzJAm6Wv","colab_type":"code","colab":{}},"source":[""],"execution_count":null,"outputs":[]},{"cell_type":"markdown","metadata":{"id":"fxYxNeqJxEmR","colab_type":"text"},"source":["**MINI CHALLENGE #2:**\n","- **Read the CSV file entitled \"S&P500_Stock_data.csv\" and print out the heading**\n","- **Print out the first 5 rows of data**\n"]},{"cell_type":"code","metadata":{"id":"yzmHo9AHxhff","colab_type":"code","colab":{}},"source":[""],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"5gflv-5oQSQg","colab_type":"code","colab":{}},"source":[""],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"um4wsztKQSSx","colab_type":"code","colab":{}},"source":[""],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"AvkJGqpPQSOi","colab_type":"code","colab":{}},"source":[""],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"HGXN70DvQt7k","colab_type":"code","colab":{}},"source":[""],"execution_count":null,"outputs":[]},{"cell_type":"markdown","metadata":{"id":"1YIpbzx8wrYj","colab_type":"text"},"source":["# EXCELLENT JOB!"]},{"cell_type":"markdown","metadata":{"id":"JOWd-_I8xlze","colab_type":"text"},"source":["# MINI CHALLENGE SOLUTIONS:\n"]},{"cell_type":"markdown","metadata":{"id":"PiBxzSjVxr4u","colab_type":"text"},"source":["**MINI CHALLENGE #1:**\n","- **Read the file 'fruits_input.txt'**\n","- **compare the text file content to the list my_fruits = [\"Apple\", \"Pepper\", \"Orange\", \"Watermelon\", \"Tomatoes\"]**"]},{"cell_type":"code","metadata":{"id":"45oMJBA2xvC5","colab_type":"code","colab":{}},"source":["my_fruits = [\"Apple\", \"Pepper\", \"Orange\", \"Watermelon\", \"Tomatoes\"]\n","\n","with open(\"/content/drive/My Drive/Colab Notebooks/Python & ML in Finance/Part 1. Python Programming Fundamentals/fruits_input.txt\", \"r\") as file:\n","    all_fruits = file.readlines()\n","\n","all_fruits = [char.rstrip('\\n') for char in all_fruits]\n","Selected_fruits = [i for i in all_fruits if i in my_fruits]\n","\n","print(Selected_fruits)\n"],"execution_count":null,"outputs":[]},{"cell_type":"markdown","metadata":{"id":"E-Ab25tzxuQU","colab_type":"text"},"source":["**MINI CHALLENGE #2:**\n","- **Read the CSV file entitled \"S&P500_Stock_data.csv\" and print out the heading**\n","- **Print out the first 5 rows of data**"]},{"cell_type":"code","metadata":{"id":"RKGDASZTxVYK","colab_type":"code","colab":{}},"source":["import csv\n","with open(\"/content/drive/My Drive/Colab Notebooks/Python & ML in Finance/Part 1. Python Programming Fundamentals/S&P500_Stock_Data.csv\", \"r\") as csvfile:\n","    readCSV = csv.reader(csvfile, delimiter=',')\n","    stock = list(readCSV)\n","    "],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"f38DGWN6xXz7","colab_type":"code","colab":{}},"source":["print(stock)"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"H6wfbUS4xX2Y","colab_type":"code","colab":{}},"source":["print(stock[0])"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"vPW5JHLExaJG","colab_type":"code","colab":{}},"source":["selected = []\n","for row in stock[1:6]:\n","    selected.append(row)"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"X7R2RDmkxaLQ","colab_type":"code","colab":{}},"source":["selected"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"yfrWoZwxwojy","colab_type":"code","colab":{}},"source":[""],"execution_count":null,"outputs":[]}]}