entityMap|blocks|key|3daka|text|这不是CSV文件，每行都是一列，您可以手动解析，例如：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|dqkg0|file+<-+'~/Downloads/PING+CONCOURS+DONNES.csv'
lines+<-+readLines(file)
columns+<-+strsplit(lines,+';')
headers+<-+sapply(columns,+'[[',+1)
data+<-+lapply(columns,+'[',+-1)
df+<-+do.call(cbind,+data)
colnames(df)+<-+headers
print(head(df))|code-block|syntax|javascript|e4lqk|请注意，您可以忽略该警告，因为缺少最后一个行尾。^0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|J|9|@]|A|@]|B|$]]|$2|C|4|D|6|E|8|K|9|@]|A|@]|B|$F|G]]|$2|H|4|I|6|7|8|L|9|@]|A|@]|B|$]]]]

This is not a CSV file, each line is a column, you can parse it manually, e.g.:

<pre><code>file &lt;- '~/Downloads/PING CONCOURS DONNES.csv'
lines &lt;- readLines(file)
columns &lt;- strsplit(lines, ';')
headers &lt;- sapply(columns, '[[', 1)
data &lt;- lapply(columns, '[', -1)
df &lt;- do.call(cbind, data)
colnames(df) &lt;- headers
print(head(df))
</code></pre>

Note that you can ignore the warning, due that the last end-of-line is missing.

entityMap|blocks|key|a3l3o|text|如下所述：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|20pv0|Hendrik+Pon|4c33f|消息指示文件的最后一行不是以结束行(EOL)字符(换行符(\n)或回车return%2Blinefeed+(\r\n))结束。|2km2u|补救办法很简单：|706f1|打开文件|fbt7c|导航到文件的最后一行|ahr8l|将光标放在该行的末尾|4dmge|按return/enter键|3ivm2|保存文件|d37nb|所以这是你没有警告的文件|6gpc3|df=read.table("C:\\Users\\Administrator\\Desktop\\tp.csv",header=F,sep=";")
+df
++++V1+++++++++++++++V2+++++++++++++++V3+++++++++++++++V4+++++++++++++++V5+++++++++++++++V6+++++++++++++++V7+++++++++++++++V8+++++++++++++++V9++++++++++++++V10
1+Date+20/12/2013+09:04+20/12/2013+09:08+20/12/2013+09:12+20/12/2013+09:16+20/12/2013+09:20+20/12/2013+09:24+20/12/2013+09:28+20/12/2013+09:32+20/12/2013+09:36
2++++1+++++++++++1,3631+++++++++++1,3632+++++++++++1,3634+++++++++++1,3633++++++++++++1,363+++++++++++1,3632+++++++++++1,3632+++++++++++1,3632+++++++++++1,3629
3++++2++++++++++0,83407++++++++++0,83408++++++++++0,83415++++++++++0,83416++++++++++0,83404++++++++++0,83386++++++++++0,83407++++++++++0,83438++++++++++0,83472
4++++3+++++++++++142,35+++++++++++142,38+++++++++++142,41++++++++++++142,4+++++++++++142,41+++++++++++142,42+++++++++++142,39+++++++++++142,42++++++++++++142,4
5++++4+++++++++++1,2263++++++++++1,22635++++++++++1,22628++++++++++1,22618++++++++++1,22614++++++++++1,22609++++++++++1,22624++++++++++1,22643+++++++++++1,2265|code-block|syntax|javascript|aff67|但我认为你不应该以这种方式阅读，因为你必须再次重塑数据框架，谢谢。^0|0|0|0|0|0|0|0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|11|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|12|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|13|9|@]|A|@]|B|$]]|$2|G|4|H|6|7|8|14|9|@]|A|@]|B|$]]|$2|I|4|J|6|7|8|15|9|@]|A|@]|B|$]]|$2|K|4|L|6|7|8|16|9|@]|A|@]|B|$]]|$2|M|4|N|6|7|8|17|9|@]|A|@]|B|$]]|$2|O|4|P|6|7|8|18|9|@]|A|@]|B|$]]|$2|Q|4|R|6|7|8|19|9|@]|A|@]|B|$]]|$2|S|4|T|6|7|8|1A|9|@]|A|@]|B|$]]|$2|U|4|V|6|W|8|1B|9|@]|A|@]|B|$X|Y]]|$2|Z|4|10|6|7|8|1C|9|@]|A|@]|B|$]]]]

As explained by <a href="https://stackoverflow.com/questions/5990654/incomplete-final-line-warning-when-trying-to-read-a-csv-file-into-r">Hendrik Pon</a>,The message indicates that the last line of the file doesn't end with an End Of Line (EOL) character (linefeed (\n) or carriage return+linefeed (\r\n)).

The remedy is simple:

<ul>
<li>Open the file</li>
<li>Navigate to the very last line of the file</li>
<li>Place the cursor the end of that line</li>
<li>Press return/enter</li>
<li>Save the file</li>
</ul>

so here is your file without warning

<pre><code>df=read.table("C:\\Users\\Administrator\\Desktop\\tp.csv",header=F,sep=";")
 df
 V1 V2 V3 V4 V5 V6 V7 V8 V9 V10
1 Date 20/12/2013 09:04 20/12/2013 09:08 20/12/2013 09:12 20/12/2013 09:16 20/12/2013 09:20 20/12/2013 09:24 20/12/2013 09:28 20/12/2013 09:32 20/12/2013 09:36
2 1 1,3631 1,3632 1,3634 1,3633 1,363 1,3632 1,3632 1,3632 1,3629
3 2 0,83407 0,83408 0,83415 0,83416 0,83404 0,83386 0,83407 0,83438 0,83472
4 3 142,35 142,38 142,41 142,4 142,41 142,42 142,39 142,42 142,4
5 4 1,2263 1,22635 1,22628 1,22618 1,22614 1,22609 1,22624 1,22643 1,2265
</code></pre>

But i think you should not read in this way because you have to again reshape the dataframe,thanks.

entityMap|blocks|key|8bmds|text|在记事本中创建数据矩阵时，我遇到了同样的问题。因此，我来到数据矩阵的最后一行，然后按enter键。现在我有了一个"n“行数据矩阵和一个新的空白行，光标位于"n%2B1”行的开头。问题解决了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data^0^^$0|$]|1|@$2|3|4|5|6|7|8|C|9|@]|A|@]|B|$]]]]

I faced the same problem while creating a data matrix in notepad.
So i came to the last row of data matrix and pressed enter. Now i have a "n" line data matrix and a new blank line with cursor at the starting of "n+1" line.
Problem solved.

entityMap|blocks|key|207hn|text|我在处理.xls文件时也遇到了同样的问题。我的解决方案是将文件保存为制表符分隔的.txt。然后，您还可以手动将.txt扩展名更改为.xls，然后可以使用以下命令打开数据帧|type|unstyled|depth|inlineStyleRanges|entityRanges|data|e3beb|..。|2bm1s|无论如何，这是一种非常粗鲁的方式来解决这个问题。^0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|G|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|H|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|I|9|@]|A|@]|B|$]]]]

I had the same problem with .xls files.
My solution is to save the file as a tab delimited .txt. Then you can also manually change the .txt extension to .xls, then you can open the dataframe with <code>read.delim</code>.

This is very rude way to overcome the issue anyway.

entityMap|blocks|key|fc4o7|text|或者您可以简单地打开该excel文件并将其另存为.csv文件，然后警告就消失了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data^0^^$0|$]|1|@$2|3|4|5|6|7|8|C|9|@]|A|@]|B|$]]]]

Or you can simply open that excel file and save it as .csv file and voila that warning is gone.

entityMap|blocks|key|nctd|text|拥有一个“合适的”CSV文件取决于最初用来生成它的软件。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|8sbm4|以Google+Sheets为例。每次通过以下方式下载CSV文件时，都会发出警告|a6p20|--包含少于五行。这可能与以下事实有关：(|9e3e|)：|eebn4|数据列数是通过查看输入的前五行(如果输入少于五行，则查看整个输入)来确定的，或者根据|17jiu|如果它被指定并且更长。|43l6h|4421v|在我短暂的经验中，如果CSV文件中的数据是矩形的，则可以忽略该警告。|9ph2i|现在考虑LibreOffice计算。无论CSV文件中有多少行，都不会出现任何警告。^0|0|0|0|0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|R|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|S|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|T|9|@]|A|@]|B|$]]|$2|G|4|H|6|7|8|U|9|@]|A|@]|B|$]]|$2|I|4|J|6|7|8|V|9|@]|A|@]|B|$]]|$2|K|4|L|6|7|8|W|9|@]|A|@]|B|$]]|$2|M|4|-4|6|7|8|X|9|@]|A|@]|B|$]]|$2|N|4|O|6|7|8|Y|9|@]|A|@]|B|$]]|$2|P|4|Q|6|7|8|Z|9|@]|A|@]|B|$]]]]

Having a "proper" CSV file depends on the software that was used to generate it in the first place.

Consider Google Sheets. The warning will be issued every time that the CSV file -- downloaded via <code>utils::download.file</code> -- contains less than five lines. This likely is related to the fact that (<code>utils:read.table</code>):

<blockquote>
 The number of data columns is determined by looking at the first five lines of input (or the whole input if it has less than five lines), or from the length of <code>col.names</code> if it is specified and is longer.
</blockquote>

In my short experience, if the data in the CSV file is rectangular, then the warning can be ignored.

Now consider LibreOffice Calc. There won't be any warnings, irrespective of the number of lines in the CSV file.

entityMap|blocks|key|8sr6c|text|我也遇到过类似的问题，但"enter方法“并没有解决这个问题。在出现上述错误后，我注意到数据帧的行数小于CSV的行数。我注意到一些非字母数值阻碍了R的导入。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4cqev|我关注了Aurezio的评论|bqqpu|下面的链接|bc55q|删除非字母数字值(包含空格)|1f2od|下面是代码片段：|686cj|Function+CleanCode(Rng+As+Range)
++++Dim+strTemp+As+String
++++Dim+n+As+Long

++++For+n+=+1+To+Len(Rng)
++++++++Select+Case+Asc(Mid(UCase(Rng),+n,+1))
++++++++++++Case+32,+48+To+57,+65+To+90
++++++++++++++++strTemp+=+strTemp+&+Mid(UCase(Rng),+n,+1)
++++++++End+Select
++++Next
++++CleanCode+=+strTemp
End+Function|code-block|syntax|javascript|ad850|然后，我使用CleanCode作为最终结果的函数^0|0|0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|R|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|S|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|T|9|@]|A|@]|B|$]]|$2|G|4|H|6|7|8|U|9|@]|A|@]|B|$]]|$2|I|4|J|6|7|8|V|9|@]|A|@]|B|$]]|$2|K|4|L|6|M|8|W|9|@]|A|@]|B|$N|O]]|$2|P|4|Q|6|7|8|X|9|@]|A|@]|B|$]]]]

I had similar issue which didn't get resolved by the &quot;enter method&quot;. After the mentioned error, I noticed the row count of the data frame was lesser than that of CSV. I noticed some non-alpha numeric values were hindering the import to R.
I followed Aurezio comment on [below link] (<a href="https://stackoverflow.com/a/29150226">https://stackoverflow.com/a/29150226</a>) to remove non-alpha numeric values (I included space)
Here the snippet:
<pre><code>Function CleanCode(Rng As Range)
 Dim strTemp As String
 Dim n As Long

 For n = 1 To Len(Rng)
 Select Case Asc(Mid(UCase(Rng), n, 1))
 Case 32, 48 To 57, 65 To 90
 strTemp = strTemp &amp; Mid(UCase(Rng), n, 1)
 End Select
 Next
 CleanCode = strTemp
End Function
</code></pre>
I then used CleanCode as a function for the final result

entityMap|blocks|key|6dnbv|text|另一种选择:从R发送额外的换行符(而不是打开文件)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|ejhob|来自|1va22|从Excel获取数据到R|a5054|cat("\n",+file+=+file.choose(),+append+=+TRUE)|code-block|syntax|javascript^0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|L|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|M|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|N|9|@]|A|@]|B|$]]|$2|G|4|H|6|I|8|O|9|@]|A|@]|B|$J|K]]]]

Another option: sending an extra linefeed from R (instead of opening the file)
From <a href="https://www.dataanalytics.org.uk/getting-data-from-excel-to-r/" rel="nofollow noreferrer">Getting Data from Excel to R</a>
<pre><code>cat(&quot;\n&quot;, file = file.choose(), append = TRUE)
</code></pre>

I have a CSV when I try to <code>read.csv()</code> that file, I get the warning warning message:

<pre><code>In read.table(file = file, header = header, sep = sep, quote = quote, :
 incomplete final line found by readTableHeader on ...
</code></pre>

And I cannot isolate the problem, despite scouring StackOverflow and R-help for solutions.

This is the Dropbox link for the data: <a href="https://www.dropbox.com/s/h0fp0hmnjaca9ff/PING%20CONCOURS%20DONNES.csv">https://www.dropbox.com/s/h0fp0hmnjaca9ff/PING%20CONCOURS%20DONNES.csv</a>

In read.table(): incomplete final line found by readTableHeader

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

 当我尝试 该文件中，我会收到警告消息： In read.table(file = file, header = header, sep = sep, quote = quote,  :  incomplete final line found by readTableHeader on ... 尽管我在StackOv...

问在read.table()中: readTableHeader找到的最后一行不完整
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在read.table()中: readTableHeader找到的最后一行不完整EN