{"id":4129,"date":"2023-08-29T12:00:40","date_gmt":"2023-08-29T06:30:40","guid":{"rendered":"https:\/\/cbsepython.in\/?p=4129"},"modified":"2023-08-29T12:00:40","modified_gmt":"2023-08-29T06:30:40","slug":"csv-file-in-python-class-12-notes","status":"publish","type":"post","link":"https:\/\/cbsepython.in\/csv-file-in-python-class-12-notes\/","title":{"rendered":"Working with CSV File in Python Class 12 Notes"},"content":{"rendered":"

CSV File in Python Class 12 Notes<\/span><\/h2>\n

What is CSV File<\/span><\/h3>\n
    \n
  • A Comma Separated Values (CSV) file is a plain text file that contains the comma (,) separated data.<\/span><\/li>\n
  • These files are often used for exchanging data between different applications.<\/span><\/li>\n
  • CSV files are usually created by programs that handle huge amounts of data. They are used to export data from spreadsheets (ex:- excel file) and databases (Ex:- Oracle, MySQL). It can be used to import data into a spreadsheet or a database.<\/span><\/li>\n<\/ul>\n

     <\/p>\n

    CSV File Structure<\/span>
    \nName, DOB, City<\/span>
    \nRam, 12-Jul-2001, Delhi<\/span>
    \nMohan, 23-Jan-2005, Delhi<\/span><\/p>\n

     <\/p>\n

    Python CSV Module<\/span><\/h3>\n
      \n
    • CSV Module is available in Python Standard Library.<\/span><\/li>\n
    • The CSV module contains classes that are used to read and write tabular form of <\/span>data into CSV format.<\/span><\/li>\n
    • To work with CSV Files, programmer have to import CSV Module.<\/span>
      \nimport csv<\/span><\/li>\n<\/ul>\n

      Methods of CSV Module :<\/span><\/h3>\n
        \n
      1. writer( )<\/span><\/li>\n
      2. reader( )<\/span><\/li>\n<\/ol>\n

        Both the methods return an Object of writer or reader class. Writer Object again have two <\/span>methods \u2013 <\/span><\/p>\n

          \n
        1. writerow( ) <\/span><\/li>\n
        2. writerows( )<\/span><\/li>\n<\/ol>\n

           <\/p>\n

          writer( ) Methods<\/span><\/h3>\n

          This function returns a writer object which is used for converting the data given by the <\/span>user into delimited strings on the file object.<\/span><\/p>\n

          writer( ) Object Methods \u2013<\/span><\/h3>\n
            \n
          • w_obj . writerow( <Sequence> ) : Write a Single Line<\/span><\/li>\n
          • w_obj . writerows ( <Nested Sequence> ) : Write Multiple Lines<\/span><\/li>\n<\/ul>\n

             <\/p>\n

            writerow() Example:-<\/span><\/h3>\n

            import csv<\/span>
            \nrow=[‘Nikhil’, ‘CEO’, ‘2’, ‘9.0’]<\/span>
            \nf=open(“myfile.csv”, ‘w’)<\/span>
            \nw_obj = csv.writer(f)<\/span>
            \nw_obj.writerow(row)<\/span>
            \nf.close()<\/span><\/p>\n

             <\/p>\n

            writerows() Example:<\/span><\/h3>\n

            import csv<\/span>
            \nrows = [[‘Nikhil’,’CEO’,’2′,’9.0′],<\/span>
            \n[‘Sanchit’,’CEO’,’2′,’9.1′]]<\/span>
            \nf=open(“myfile.csv”,’w’)<\/span>
            \nw_obj = csv.writer(f)<\/span>
            \nw_obj.writerows(rows)<\/span>
            \nf.close()<\/span><\/p>\n

             <\/p>\n

            reader( ) Methods<\/span><\/h3>\n

            This function returns a reader object which will be used to iterate over lines of a given <\/span>CSV file.<\/span><\/p>\n

            r_obj = csv.reader(csvfile_obj)<\/span><\/p>\n

            To access each row, we have to iterate over this Object.<\/span>
            \nfor i in r_obj:<\/span>
            \nprint(i)<\/span><\/p>\n

            import csv<\/span>
            \nf=open(“myfile.csv”,’r’)<\/span>
            \nr_obj = csv.reader(f)<\/span>
            \nfor data in r_obj:<\/span>
            \nprint(data)<\/span>
            \nf.close()<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

            CSV File in Python Class 12 Notes What is CSV File A Comma Separated Values (CSV) file is a plain text file that contains the comma (,) separated data. These files are often used for exchanging data between different applications. CSV files are usually created by programs that handle huge amounts of data. They are […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16,20],"tags":[],"class_list":["post-4129","post","type-post","status-publish","format-standard","hentry","category-cbse-sample-papers-class-12","category-cbse-computer-science-with-python-class-12"],"_links":{"self":[{"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/posts\/4129","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/comments?post=4129"}],"version-history":[{"count":0,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/posts\/4129\/revisions"}],"wp:attachment":[{"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/media?parent=4129"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/categories?post=4129"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/tags?post=4129"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}