Tuesday, August 18, 2020

Powershell Fastest and Efficient way to read huge csv file

$row_count = 0 
Get-Content '.\big_file_name_with_path.csv' -ReadCount 2000 | foreach { $row_count += $_.count }
$row_count

at No comments:
Labels: , ,
Subscribe to: Posts (Atom)

Find the Subtasks That Did Not Execute Leetcode

 with recursive CTE as ( SELECT task_id,subtasks_count,1 as result FROM Tasks UNION ALL SELECT CTE.task_id,subtasks_count,result+1 FROM CTE ...

  • Median of numbers
    create Table numbers (number int,frequency int); insert into numbers values (1,2); insert into numbers values (4,1); insert into numbers val...
  • Median Employee Salary
     Create table If Not Exists Employee (Id int, Company varchar(255), Salary int); Truncate table Employee; insert into Employee (Id, Company,...
  • Find the Subtasks That Did Not Execute Leetcode
     with recursive CTE as ( SELECT task_id,subtasks_count,1 as result FROM Tasks UNION ALL SELECT CTE.task_id,subtasks_count,result+1 FROM CTE ...