Lab 1

Use Pandas to implement the following instructions:

Note: Be ready to explain your code being able to answer practical

and theoretical questions


Step 1. Import the necessary libraries


Step 2. Import the dataset from this address

 https://raw.githubusercontent.com/justmarkham/DAT8/master/data/u.user


Step 3. Assign it to a variable called users and use the 'user_id' as index


Step 4. See the first 20 entries


Step 5. See the last 15 entries


Step 6. What is the number of observations in the dataset?


Step 7. What is the number of columns in the dataset?


Step 8. Print the name of all the columns.


Step 9. How is the dataset indexed?


Step 10. What is the data type of each column?



Step 11. Print only the occupation column



Step 12. How many different occupations there are in this dataset?



Step 13. What is the most frequent occupation?



Step 14. Summarize the DataFrame.



Step 15. Summarize all the columns



Step 16. Summarize only the occupation column



Step 17. What is the mean age of users?



Step 18. What is the age with least occurrence?

Comments

Post a Comment

Popular posts from this blog

Lab 3

\ Step 1. Import the necessary libraries In [ ]: Step 2. Import the dataset from this address. https://raw.githubusercontent.com/justmarkham/DAT8/master/data/drinks.csv Step 3. Assign it to a variable called drinks. In [ ]: Step 4. Which continent drinks more beer on average? In [ ]: Step 5. For each continent print the statistics for wine consumption. In [ ]: Step 6. Print the mean alcoohol consumption per continent for every column In [ ]: Step 7. Print the median alcoohol consumption per continent for every column In [ ]: Step 8. Print the mean, min and max values for spirit consumption. This time output a DataFrame In [ ]:
Read more

Lab 10

Step 1. Import the necessary libraries In [ ]: Step 2. Import the dataset from this address. https://github.com/guipsamora/pandas_exercises/blob/master/04_Apply/Students_Alcohol_Consumption/student-mat.csv Step 3. Assign it to a variable called df. In [ ]: Step 4. For the purpose of this exercise slice the dataframe from 'school' until the 'guardian' column In [ ]: Step 5. Create a lambda function that captalize strings. In [ ]: Step 6. Capitalize both Mjob and Fjob In [ ]: Step 7. Print the last elements of the data set. In [ ]: Step 8. Did you notice the original dataframe is still lowercase? Why is that? Fix it and captalize Mjob and Fjob. In [ ]: Step 9. Create a function called majority that return a boolean value to a new column called legal_drinker In [ ]: In [ ]: Step 10. Multiply every number of the dataset by 10. I know this makes no sense, don't forget it is just an exercise In [ ]: In [ ]:
Read more

Lab 2 (Filtering and Sorting)

Step 1. Import the necessary libraries Step 2. This is the data given as a dictionary # Create an example dataframe about a fictional army raw_data = {'regiment': ['Nighthawks', 'Nighthawks', 'Nighthawks', 'Nighthawks', 'Dragoons', 'Dragoons', 'Dragoons', 'Dragoons', 'Scouts', 'Scouts', 'Scouts', 'Scouts'],             'company': ['1st', '1st', '2nd', '2nd', '1st', '1st', '2nd', '2nd','1st', '1st', '2nd', '2nd'],             'deaths': [523, 52, 25, 616, 43, 234, 523, 62, 62, 73, 37, 35],             'battles': [5, 42, 2, 2, 4, 7, 8, 3, 4, 7, 8, 9],             'size': [1045, 957, 1099, 1400, 1592, 1006, 987, 849, 973, 1005, 1099, 1523],             'veterans': [1, 5, 62, 26, 73, 37, 949, 48, 48, 435, 63, 345],             'readines...
Read more