我寫了以下代碼：
BEGIN{FS=OFS=","}
NR==FNR &&
$7{sum =$7;
elementos ;
next}
!$7{$7=media}
{print}
ENDFILE{media=sum/elementos}
此awk腳本將平均年齡添加到“年齡”列的空單元格中。
代碼的執行如下：
awk -f c_awk.awk train3.csv
現在我正在嘗試使用 .csv 檔案將所做的更改保存在新的 CSV 檔案中awk。（新檔案：train4.csv）
我一直> ./c_awk.awk/train4.csv在最后一行嘗試，
但它不起作用。
awk: c_awk.awk:12: ENDFILE{media=sum/elementos}> /tmp/train4.csv
awk: c_awk.awk:12: ^ syntax error
awk: c_awk.awk:12: ENDFILE{media=sum/elementos}> /tmp/train4.csv
awk: c_awk.awk:12: ^ syntax error
我試圖實施更改的檔案如下所示：
PassengerId,Survived,Pclass,Name,Sex,Age,SibSp,Parch,Ticket,Fare,Cabin,Embarked
1,0,3,"Braund, Mr. Owen Harris",male,22,1,0,A/5 21171,7.25,,S
2,1,1,"Cumings, Mrs. John Bradley (Florence Briggs Thayer)",female,38,1,0,PC 17599,71.2833,C85,C
3,1,3,"Heikkinen, Miss. Laina",female,26,0,0,STON/O2. 3101282,7.925,,S
4,1,1,"Futrelle, Mrs. Jacques Heath (Lily May Peel)",female,35,1,0,113803,53.1,C123,S
5,0,3,"Allen, Mr. William Henry",male,35,0,0,373450,8.05,,S
6,0,3,"Moran, Mr. James",male,,0,0,330877,8.4583,,Q
7,0,1,"McCarthy, Mr. Timothy J",male,54,0,0,17463,51.8625,E46,S
預期結果如下：
1,0,3,"Braund, Mr. Owen Harris",male,22,1,0,A/5 21171,7.25,,S
2,1,1,"Cumings, Mrs. John Bradley (Florence Briggs Thayer)",female,38,1,0,PC 17599,71.2833,C85,C
3,1,3,"Heikkinen, Miss. Laina",female,26,0,0,STON/O2. 3101282,7.925,,S
4,1,1,"Futrelle, Mrs. Jacques Heath (Lily May Peel)",female,35,1,0,113803,53.1,C123,S
5,0,3,"Allen, Mr. William Henry",male,35,0,0,373450,8.05,,S
6,0,3,"Moran, Mr. James",male,,0,0,330877,8.4583,,Q
7,0,1,"McCarthy, Mr. Timothy J",male,54,0,0,17463,51.8625,E46,S
謝謝。
uj5u.com熱心網友回復：
awk -f c_awk.awk train3.csv > /tmp/train4.csv
或只是更改{print}為{print > "/tmp/train4.csv"}
您的腳本包含幾個與寫入新檔案無關的問題，我懷疑您不知道 - 您應該發布一個包含簡潔、可測驗的示例輸入和預期輸出的新問題，以便我們可以幫助您解決問題，因為尚不完全清楚是什么您希望該腳本執行
轉載請註明出處，本文鏈接：https://www.uj5u.com/gongcheng/391117.html
上一篇：使用CRLF而不是LF的CSVWriter(Python)
下一篇：使用bash洗掉CSV檔案