1.4 CSV file in Python

-

 v  CSV file in python: -

  • A CSV file in Python is a Comma-Separated Values file used to store tabular data in plain text format, where each line represents a row, and values in a row are separated by commas (,).
  • Each row in the file corresponds to a record.
  • Columns are separated by a delimiter (comma by default, but can be ;, \t, or others).
  • CSV files are human-readable and can be opened in text editors, Excel, Google Sheets, etc.
  • Python uses CSV module to read and write the CSV files.

 

1. Writing CSV files: -

  • To write to a CS to write CSV file in Python, we use the csv.writer( ) method.
  • The csv.writer( ) method returns a writer object that converts the user’s data into a delimited string.
  • This string can later be used to write into CSV files using the writerow( ) method.
  • The two methods for writing to CSV are:

writerow( ): This method writes a single row at a time. Field row can be written using this method.

writerows( ): This method is used to write multiple rows at a time. This can be used to write row’s list.


Example: -



output: -


2. Reading CSV files: -

  • To read a CSV file, we use csv.reader( ) method.
  • The reader class from CSV module is used for reading CSV files.
  • The reader( ) method of CSV module returns the reader object that iterates throughout the lines in the specified CSV document.
  • We should specify the mode as ‘r’.


Example: -

output: -



Popular posts from this blog

operators in c programming

-
Image
v Operators: - An operator is a symbol that tells or intimates to the compiler to perform specific calculations or manipulations on one or more operands. Operators are essential for performing computations and making decisions in programs.   a + b is an operation a & b are operands + is an operator   Based on number of operands involved: 1.      Unary operators: - unary operators can be applied on only one operator. Example: -   ++ , -- , - (unary minus) , sizeof , ~ (compliment) , ! (not).   2.      Binary operators: - binary operators can be applied on two operands. Example: -   + , -,   * , / , etc.   3.    Ternary operators: - Ternary operator can be applied on three operands. Example: -   ?: (ternary conditional operator).   C supports several operators, can be classified into following...
Read more

2.4 Arrays in c programming

-
Image
  Arrays: - An array is a collection of elements of the same data type stored in contiguous memory locations. It is a derived data type and a homogenous data structure. It is a variable which can store multiple values of the same type under a single variable name, making it easier to manage and manipulate related data. The size of an array is fixed. To access the elements of an array, we use indexes or subscripts accordingly. array index or subscript is used to identify array elements address. Array index or subscript starts with 0 to n-1.   Declaration of an array: - The declaration of an array means telling the compiler to create an array variable and reserving memory for a fixed number of elements of the same data type. Initialization of an array: - Initializing an array means assigning initial values to its elements. Types of arrays: - Arrays are classified based on the number of dimensions they have:             ...
Read more

2.1 Control statements in C programming (sequential & conditional)

-
Image
Control statements in C: - C is a structure-orientated programming language; the statements that are used to control the flow of execution of a program are called control structures. The statements provide a specific order to execute the C program. In C programming, we have four types of control structures. Sequential control structures Conditional control structures Iterative control structures Jumping control structures   1) Sequential control structures: - The C program is a collection of instructions or set of statements which are executed sequentially in a user-specific order. No statement is slipped, and no statement is executed more than once.                   Syntax: -                Flow chart: -                Example: - Output: - 1) Conditional control structures: - It is also known as selection, branchi...
Read more