How to count the number of lines in a CSV file in Python?

How to get the number of lines in a file using PHP?

Last Updated : 22 Jan, 2021

Given a file reference, find the number of lines in this file using PHP. There are a total of 3 approaches to solve this.

test.txt: This file is used for testing all the following PHP codes

Geeks
For
Geeks

Approach 1: Load the whole file into memory and then use the count() function to return the number of lines in this file.

Example:

PHP

<?php 
    $filePath = "test.txt"; 
    $lines = count(file($filePath)); 
    echo $lines; 
?> 

Output:

This approach loads the whole file into memory which can cause a memory overflow issue.

Approach 2: Here we will load only one line of files at a time which is better than the1st approach. PHP fopen() function is used to open a file or URL. The PHP fgets() function is used to return a line from an open file. The fclose() function is used to close the file pointer.

Example:

PHP

<?php 
    $filePath="test.txt"; 
    $linecount = 0; 
    $handleFile = fopen($file, "r"); 
    while(!feof($handleFile)){ 
      $line = fgets($handleFile); 
      $linecount++; 
    } 
  
    fclose($handleFile); 
  
    echo $linecount; 
?> 

Output:

What if 1GB file has only one line in it. This code will load the whole 1GB of data which can cause a memory overflow issue.

Approach 3: We will load only a specific size of data into memory. We don’t care about line breaks at the time of loading. We will iterate on the loaded data to count the number of line breaks in it.

Example:

PHP

<?php 
    $filePath="test.txt"; 
    $linecount = 0; 
    $handleFile = fopen($filePath, "r"); 
  
    while(!feof($handleFile)){ 
      // We are loading only 4096 bytes of data at a time. 
      $line = fgets($handleFile, 4096); 
        
      // We are using PHP_EOL (PHP End of Line) 
      //to count number of line breaks in currently loaded data. 
      $linecount = $linecount + substr_count($line, PHP_EOL); 
    } 
  
    fclose($handleFile); 
  
    echo $linecount; 
?> 

Output:

This is a better approach in terms of space but, note that we are iterating on our data twice So, the time taken will be double.

How to count the number of lines in a CSV file in Python?

P

pratikraut0000

Improve

Article Tags :

Similar Reads

How to get total number of elements used in array in PHP ?

In this article, we will discuss how to get total number of elements in PHP from an array. We can get total number of elements in an array by using count() and sizeof() functions. Using count() Function: The count() function is used to get the total number of elements in an array. Syntax: count(arra

How to count the number of lines in a CSV file in Python?

CSV (Comma Separated Values) is a simple file format used to store tabular data, such as a spreadsheet or database. A CSV file stores tabular data (numbers and text) in plain text. Each line of the file is a data record. Each record consists of one or more fields, separated by commas. The use of the

How to Count number of Lines in a Git Repository?

Counting the number of lines in a Git repository can be useful for various reasons, such as understanding the size of the project or monitoring codebase growth over time. There are several methods to achieve this, including using Git command line tools, the CLOC (Count Lines of Code) tool, and custo

How to get the size of a collection using Node.js ?

The collection.countDocuments() is the method of the mongodb module in the node.js that is used to count the total number of documents present in the collection of the particular database in the MongoDB. Syntax: collection.countDocuments(Query)Parameters: This method takes the following one paramete

How to find Sum the Digits of a given Number in PHP ?

We will explore how to find the sum of the digits of a given number in PHP. This task involves extracting each digit from the number and adding them together to get the final sum. Table of Content Using a loop to extract digits one by oneUsing mathematical operations to extract digitsUsing a loop to

How to count the number of pages in a PDF file in Python

In this article, we will see how can we count the total number of pages in a PDF file in Python, For this article there is no such prerequisite, we will use PyPDF2 library for this purpose. PyPDF2 is a free and open-source pure-Python PyPDF library capable of performing many tasks like splitting, me

How to Get Number of Days in Current Month in PHP?

This article will show you how to get the number of days in the current month in PHP. In PHP, you may need to find the number of days in the current month for various purposes, such as generating a calendar or performing date calculations. There are three approaches to get the number of days in the

How to get file name from a path in PHP ?

In this article, we will see how to get the file name from the path in PHP, along with understanding its implementation through the examples. We have given the full path & we need to find the file name from the file path. For this, we will following below 2 methods: Using the basename() function

How to Convert a Given Number to Words in PHP?

Given an integer N, your task is to convert the given number into words using PHP. Examples: Input: N = 958237764Output: Nine Hundred Fifty Eight Million Two Hundred Thirty Seven Thousand Seven Hundred Sixty FourInput: N = 5000Output: Five ThousandBelow are the approaches to convert a given number t

How to Count Number of Rows and Columns in a Table Using jQuery?

Given an HTML document containing a table, the task is to count the number of rows and columns in that table using JQuery. There are a few methods available in jQuery to count the number of rows and columns in an HTML table. Table of Content By iterating through the rows and columnsBy using the leng