Page 259 - Robotics and AI class 10
P. 259

[[201 194 193]
                 [182 178 175]

                 [168 165 164]
                 …

                 [128 120 117]
                 [126 116 112]

                 [124 114 109]]
              6.  Reading a .csv file into a Pandas DataFrame .

              Ans.  import pandas as pd
                 df = pd.read_csv('friends.csv')   # Read the CSV file into a DataFrame

                 print(df)  # Display the DataFrame
                 Output:

                 SOL     Adm No       Name               Percentage
                 0       111          Aman Verma         87

                 1       152          Vartika Sen        89
                 2       123          Shipra Virmani     80

                 3       214          Jyoti Batra        78
                 4       167          Ayana Joshi        92
                 5       142          Ekta Mishra        76

                 6       216          Mansi Kapoor       72
                 7       147          Shivani Monga      81

                 8       181          Poonam Gupta       67
              7.  Reading json data into a Pandas DataFrame.

              Ans.  import pandas as pd
                 df = pd.read_json('mydata.json')  # Read the JSON file into a DataFrame

                 print(df) # Display the DataFrame
                 Output:
                 #      Courses     Fee        Duration
                 #0     Spark       25000      50 Days

                 #1     Pandas      20000      35 Days
                 #2     Java        15000      40 days

              8.  Basic data analysis on data with info(), tail(), head() commands.

              Ans.  import pandas as pd
                 # Sample dataset of student information
                 data = {

                     'Name': ['Reena', 'Iqbal', 'Jacob', 'Eshaan', 'Sneha'],
                     'Age': [15,16,14,17,16],
                                                                                            Assignment     257
   254   255   256   257   258   259   260   261   262   263   264