Masters, you have a file named aa CSV, the content is as follows:
Student id, name, math, Chinese, English achievement
21, li si, 98,23,12
12, wang network, 23,12,56
Now to the above data processing into is as follows:
Student id, name, name, total score (mathematics) + Chinese + English scores, ranking
Four, 21, lee, 133, 1
12, king, web, 91,
Stored in the bb. CSV, please comment ah, wait

CodePudding user response:

Use excel spreadsheet to deal with much good...

CodePudding user response:

A split in the two-dimensional array: first to use the split in accordance with the resolution of the carriage return, and comma split into two dimensional array

And then pick out what you need to regenerate the string written B

Also can use excel, because excel can directly read the CSV file.

CodePudding user response:

Excel can generate a CSV file?

CodePudding user response:

For each master source!