Pandas Practice Set-1: Exercises, Practice, Solution
[An editor is available at the bottom of the page to write and execute the scripts. Go to the editor]
Pandas Practice Set-1 [65 exercises with solution]
Diamonds:
This classic dataset contains the prices and other attributes of almost 54,000 diamonds. It's a great dataset for beginners learning to work with data analysis and visualization.
Content
Column Name | Description |
---|---|
price | price in US dollars (\$326--\$18,823) |
carat | weight of the diamond (0.2--5.01) |
cut | quality of the cut (Fair, Good, Very Good, Premium, Ideal) |
color | diamond colour, from J (worst) to D (best) |
clarity | a measurement of how clear the diamond is (I1 (worst), SI2, SI1, VS2, VS1, VVS2, VVS1, IF (best)) |
x | length in mm (0--10.74) |
y | width in mm (0--58.9) |
z | depth in mm (0--31.8) |
depth | total depth percentage = z / mean(x, y) = 2 * z / (x + y) (43--79) |
table | width of top of diamond relative to widest point (43--95) |
Access dimond.csv
import pandas as pd
diamonds = pd.read_csv('https://raw.githubusercontent.com/mwaskom/seaborn-data/master/diamonds.csv')
print(diamonds)
Source: https://www.kaggle.com/shivam2503/diamonds
1. Write a Pandas program to read a csv file from a specified source and print the first 5 rows.
Click me to see the sample solution
2. Write a Pandas program to read a dataset from diamonds DataFrame and modify the default columns values and print the first 6 rows.
Click me to see the sample solution
3. Write a Pandas program to select a series from diamonds DataFrame. Print the content of the series.
Click me to see the sample solution
4. Write a Pandas program to create a new 'Quality -color' Series (use bracket notation to define the Series name) of the diamonds DataFrame.
Click me to see the sample solution
5. Write a Pandas program to find the number of rows and columns and data type of each column of diamonds Dataframe.
Click me to see the sample solution
6. Write a Pandas program to summarize only 'object' columns of the diamonds Dataframe.
Click me to see the sample solution
7. Write a Pandas program to rename two of the columns of the diamonds Dataframe.
Click me to see the sample solution
8. Write a Pandas program to rename all the columns of the diamonds Dataframe.
Click me to see the sample solution
9. Write a Pandas program to remove the second column of the diamonds Dataframe.
Click me to see the sample solution
10. Write a Pandas program to remove multiple columns at once of the diamonds Dataframe.
Click me to see the sample solution
11. Write a Pandas program to remove multiple rows at once (axis=0 refers to rows) from diamonds dataframe.
Click me to see the sample solution
12. Write a Pandas program to sort the 'cut' Series in ascending order (returns a Series) of diamonds Dataframe.
Click me to see the sample solution
13. Write a Pandas program to sort the 'price' Series in descending order (returns a Series) of diamonds Dataframe.
Click me to see the sample solution
14. Write a Pandas program to sort the entire diamonds DataFrame by the 'carat' Series in ascending and descending order.
Click me to see the sample solution
15. Write a Pandas program to filter the DataFrame rows to only show carat weight at least 0.3.
Click me to see the sample solution
16. Write a Pandas program to convert a python list to pandas series.
Click me to see the sample solution
17. Write a Pandas program to find the details of the diamonds where length>5, width>5 and depth>5.
Click me to see the sample solution
18. Write a Pandas program to find the diamonds that are either Premium or Ideal.
Click me to see the sample solution
19. Write a Pandas program to find the diamonds that are with a Fair or Good or Premium.
Click me to see the sample solution
20. Write a Pandas program to display all column labels of diamonds DataFrame.
Click me to see the sample solution
21. Write a Pandas program to read only a subset of 3 rows from diamonds DataFrame.
Click me to see the sample solution
22. Write a Pandas program to iterate through diamonds DataFrame.
Click me to see the sample solution
23. Write a Pandas program to drop all non-numeric columns from diamonds DataFrame.
Click me to see the sample solution
24. Write a Pandas program to include only numeric columns in the diamonds DataFrame.
Click me to see the sample solution
25. Write a Pandas program to pass a list of data types to only describe certain types of diamonds DataFrame.
Click me to see the sample solution
26. Write a Pandas program to calculate the mean of each numeric column of diamonds DataFrame.
Click me to see the sample solution
27. Write a Pandas program to calculate the mean of each row of diamonds DataFrame.
Click me to see the sample solution
28. Write a Pandas program to calculate the mean of price for each cut of diamonds DataFrame.
Click me to see the sample solution
29. Write a Pandas program to calculate count, minimum, maximum price for each cut of diamonds DataFrame.
Click me to see the sample solution
30. Write a Pandas program to create a side-by-side bar plot of the diamonds DataFrame.
Click me to see the sample solution
31. Write a Pandas program to count how many times each value in cut series of diamonds DataFrame occurs.
Click me to see the sample solution
32. Write a Pandas program to display percentages of each value of cut series occurs in diamonds DataFrame.
Click me to see the sample solution
33. Write a Pandas program to display the unique values in cut series of diamonds DataFrame.
Click me to see the sample solution
34. Write a Pandas program to count the number of unique values in cut series of diamonds DataFrame.
Click me to see the sample solution
35. Write a Pandas program to compute a cross-tabulation of two Series in diamonds DataFrame.
Click me to see the sample solution
36. Write a Pandas program to calculate various summary statistics of cut series of diamonds DataFrame.
Click me to see the sample solution
37. Write a Pandas program to create a histogram of the 'carat' Series (distribution of a numerical variable) of diamonds DataFrame.
Click me to see the sample solution
38. Write a Pandas program to create a bar plot of the 'value_counts' for the 'cut' series of diamonds DataFrame.
Click me to see the sample solution
39. Write a Pandas program to create a DataFrame of booleans (True if missing, False if not missing) from diamonds DataFrame.
Click me to see the sample solution
40. Write a Pandas program to count the number of missing values in each Series of diamonds DataFrame.
Click me to see the sample solution
41. Write a Pandas program to check the number of rows and columns and drop those row if 'any' values are missing in a row of diamonds DataFrame.
Click me to see the sample solution
42. Write a Pandas program to drop a row if any or all values in a row are missing of diamonds DataFrame on two specific columns.
Click me to see the sample solution
43. Write a Pandas program to set an existing column as the index of diamonds DataFrame.
Click me to see the sample solution
44. Write a Pandas program to set an existing column as the index of diamonds DataFrame and restore the index name, and move the index back to a column.
Click me to see the sample solution
45. Write a Pandas program to access a specified Series index and the Series values of diamonds DataFrame.
Click me to see the sample solution
46. Write a Pandas program to sort a Series by its values and index of diamonds DataFrame.
Click me to see the sample solution
47. Write a Pandas program to calculate the multiply of length, width and depth for each cut of diamonds DataFrame.
Click me to see the sample solution
48. Write a Pandas program to concatenate the diamonds DataFrame with the 'color' Series.
Click me to see the sample solution
49. Write a Pandas program to read specified rows and all columns of diamonds DataFrame.
Click me to see the sample solution
50. Write a Pandas program to read rows 0, 5, 7 and all columns of diamonds DataFrame.
Click me to see the sample solution
51. Write a Pandas program to read rows 2 through 5 and all columns of diamonds DataFrame.
Click me to see the sample solution
52. Write a Pandas program to read rows 0 through 2 (inclusive), columns 'color' and 'price' of diamonds DataFrame.
Click me to see the sample solution
53. Write a Pandas program to read rows 0 through 2 (inclusive), columns 'color' through 'price' (inclusive) of diamonds DataFrame.
Click me to see the sample solution
54. Write a Pandas program to read rows in which the 'cut' is 'Premium', column 'color' of diamonds DataFrame.
Click me to see the sample solution
55. Write a Pandas program to read rows in positions 0 and 1, columns in positions 0 and 3 of diamonds DataFrame.
Click me to see the sample solution
56. Write a Pandas program to read rows in positions 0 through 4, columns in positions 1 through 4 of diamonds DataFrame.
Click me to see the sample solution
57. Write a Pandas program to read rows in positions 0 through 4 (exclusive) and all columns of diamonds DataFrame.
Click me to see the sample solution
58. Write a Pandas program to read rows 2 through 5 (inclusive), columns in positions 0 through 2 (exclusive) of diamonds DataFrame.
Click me to see the sample solution
59. Write a Pandas program to print a concise summary of diamonds DataFrame.
Click me to see the sample solution
60. Write a Pandas program to get the true memory usage by diamonds DataFrame.
Click me to see the sample solution
61. Write a Pandas program to calculate the memory usage for each Series (in bytes) of diamonds DataFrame.
Click me to see the sample solution
62. Write a Pandas program to get randomly sample rows from diamonds DataFrame.
Click me to see the sample solution
63. Write a Pandas program to get sample 75% of the diamonds DataFrame's rows without replacement and store the remaining 25% of the rows in another DataFrame.
Click me to see the sample solution
64. Write a Pandas program to read the diamonds DataFrame and detect duplicate color.
Note: duplicated () function returns boolean Series denoting duplicate rows, optionally only considering certain columns.
Click me to see the sample solution
65. Write a Pandas program to count the duplicate rows of diamonds DataFrame.
Click me to see the sample solution
Python Code Editor:
More to Come !
Do not submit any solution of the above exercises at here, if you want to contribute go to the appropriate exercise page.
[ Want to contribute to Python Pandas exercises? Send your code (attached with a .zip file) to us at w3resource[at]yahoo[dot]com. Please avoid copyrighted materials.]
Test your Python skills with w3resource's quiz
- Weekly Trends and Language Statistics
- Weekly Trends and Language Statistics