How to resolve the algorithm CSV data manipulation step by step in the Racket programming language

Published on 12 May 2024 09:40 PM
#Racket

How to resolve the algorithm CSV data manipulation step by step in the Racket programming language

Table of Contents

Problem Statement

CSV spreadsheet files are suitable for storing tabular data in a relatively portable way. The CSV format is flexible but somewhat ill-defined.
For present purposes, authors may assume that the data fields contain no commas, backslashes, or quotation marks.

Read a CSV file, change some values and save the changes back to a file. For this task we will use the following CSV file: Suggestions

Let's start with the solution:

Step by Step solution about How to resolve the algorithm CSV data manipulation step by step in the Racket programming language

Source code in the racket programming language

#lang racket
(require (planet neil/csv:1:=7) net/url)

(define make-reader
  (make-csv-reader-maker
   '((separator-chars              #\,)
     (strip-leading-whitespace?  . #t)
     (strip-trailing-whitespace? . #t))))

(define (all-rows port)
  (define read-row (make-reader port))
  (define head (append (read-row) '("SUM")))
  (define rows (for/list ([row (in-producer read-row '())])
                 (define xs (map string->number row))
                 (append row (list (~a (apply + xs))))))
  (define (->string row) (string-join row "," #:after-last "\n"))
  (string-append* (map ->string (cons head rows))))


(define csv-file 
  "C1, C2, C3, C4, C5
    1,  5,  9, 13, 17
    2,  6, 10, 14, 18
    3,  7, 11, 15, 19
    4,  8, 12, 16, 20")

(display (all-rows (open-input-string csv-file)))

You may also check:How to resolve the algorithm Guess the number/With feedback step by step in the Common Lisp programming language
You may also check:How to resolve the algorithm Idoneal numbers step by step in the FutureBasic programming language
You may also check:How to resolve the algorithm Variable-length quantity step by step in the Kotlin programming language
You may also check:How to resolve the algorithm Walk a directory/Recursively step by step in the BBC BASIC programming language
You may also check:How to resolve the algorithm Determine if a string has all the same characters step by step in the Action! programming language