Perform following tasks in Jupyter Notebooks of Python. Do not forget to show your necessary output after important steps. Once all completed snapshot your scripts to your word file. You should use your googling skills to find the solutions of encountered problems while coding. Stackover and github are you best friends.

1. Create at least three separate lists of restaurant foods with at least two or three items in each list(Salads: Italian, Ceasar, Greek; Entree: Spaghetti, Alfredo...). Make sure to include at least 3 categories (salad, entree, appetizer, dessert ). Using for loop, create a conditional statement that iterates through the list of customer order and categorizes items into different categories. For example, for your print statement for each item should look like: Cheesecake This is Dessert!!!. (you need to use a combination of for loop and if statements)
2. Create a function with a conditional statement that, for any given amount, calculates a discount under following policy: for amounts under $100 will not be given any discount, for amounts between $100 and $200 discount of 2% is given, all amounts above $200 will receive 5% discount. Check you function with list of amounts at different ranges.
3. Load Workshop 5.csv (in Week 4 files) using Pandas, keep only following columns: Journal_ID, Journal_ID_Line_Number, GL_Account_Number, Amount, Amount_Credit_Debit_Indicator, Entered_By, Period. Rename all columns to the same names with capital letters.
4. Pivot Amount column of the manipulated table by Period and Amount_Credit_Debit_Indicator. Show both sum and count pivoting.