blocks|key|3020935|text|如果您能够使csv或html可用，并可通过url访问-您可以在google工作表中使用这一点。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3020936|=IMPORTDATA("url+to+the+csv/html+file")|code-block|syntax|javascript|3020937|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

If you are able to make the csv or html available and reachable by a url - you can use this in google sheets.

<pre><code>=IMPORTDATA("url to the csv/html file")
</code></pre>

blocks|key|3108337|text|尝试使用to_clipboard()方法。例如，对于数据，df：df.to_clipboard()将将所述数据复制到剪贴板。然后，可以将其粘贴到Excel或Google中。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|3108338|entityMap^0|W|H|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

Try using the to_clipboard() method. E.g., for a dataframe, df: df.to_clipboard() will copy said dataframe to your clipboard. You can then paste it into Excel or Google Docs.

blocks|key|3020983|text|根据我的经验，SpreadSheet使用制表(\t)分隔单元格，用换行符(\n)分隔行。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3020984|假设这一点，我编写了一个从剪贴板数据转换的简单函数：|3020985|def+from_excel_to_list(copy_text):
++++"""Use+it+to+copy+and+paste+data+from+SpreadSheet+software
++++(MS+Excel,+Libreoffice)+and+convert+to+a+list
++++"""
++++if+isinstance(copy_text,+str):
++++++++array+=+[]
++++++++rows+=+copy_text.split("\n")++#+splits+rows
++++++++for+row+in+rows:
++++++++++++if+len(row):++#+removes+empty+lines
++++++++++++++++array.append(row.split("\t"))
++++++++return+array
++++else:
++++++++raise+TypeError("text+must+be+string")|code-block|syntax|javascript|3020986|您可以定义木星内部的功能并以这样的方式使用它：|3020987|在SpreadSheet上使用ctrl-c进行复制，然后调用函数from_excel_to_list，在双括号内粘贴ctrl-v的数据。|3020988|my_excel_converted+=+from_excel_to_list("""Paste+here+with+ctrl-v+the+text""")|3020989|示例|offset|length|style|BOLD|3020990|来自ctrl-c的数据：|3020991|N+++U+++tot
1+++18,236++18,236
17++20,37+++346,29
5+++6,318+++31,59|3020992|调用该函数：|3020993|from_excel_to_list("""N+U+++tot
1+++18,236++18,236
17++20,37+++346,29
5+++6,318+++31,59
""")|3020994|结果是木星：|3020995|[['N',+'U',+'tot'],
+['1',+'18,236',+'18,236'],
+['17',+'20,37',+'346,29'],
+['5',+'6,318',+'31,59']]|3020996|这是进一步阐述的基础。同样的方法也可以用于获得字典、名称等等。|3020997|entityMap^0|0|0|0|0|0|0|0|2|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1A|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1B|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|1C|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|1D|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|1E|8|@]|9|@]|A|$]]|$1|M|3|N|5|F|7|1F|8|@]|9|@]|A|$G|H]]|$1|O|3|P|5|6|7|1G|8|@$Q|1H|R|1I|S|T]]|9|@]|A|$]]|$1|U|3|V|5|6|7|1J|8|@]|9|@]|A|$]]|$1|W|3|X|5|F|7|1K|8|@]|9|@]|A|$G|H]]|$1|Y|3|Z|5|6|7|1L|8|@]|9|@]|A|$]]|$1|10|3|11|5|F|7|1M|8|@]|9|@]|A|$G|H]]|$1|12|3|13|5|6|7|1N|8|@]|9|@]|A|$]]|$1|14|3|15|5|F|7|1O|8|@]|9|@]|A|$G|H]]|$1|16|3|17|5|6|7|1P|8|@]|9|@]|A|$]]|$1|18|3|-4|5|6|7|1Q|8|@]|9|@]|A|$]]]|19|$]]

In my experience SpreadSheet uses tabulation (\t) to separate cells and newline (\n) to separate rows.

Assuming this I wrote a simple function to convert from clipboard data:

<pre><code>def from_excel_to_list(copy_text):
 """Use it to copy and paste data from SpreadSheet software
 (MS Excel, Libreoffice) and convert to a list
 """
 if isinstance(copy_text, str):
 array = []
 rows = copy_text.split("\n") # splits rows
 for row in rows:
 if len(row): # removes empty lines
 array.append(row.split("\t"))
 return array
 else:
 raise TypeError("text must be string")
</code></pre>

You can define the function inside Jupiter and use it in this way:

Copy with ctrl-c on the SpreadSheet and than call the function from_excel_to_list pasting the data with ctrl-v inside the double brackets

<pre><code>my_excel_converted = from_excel_to_list("""Paste here with ctrl-v the text""")
</code></pre>

Example

Data from ctrl-c:

<pre><code>N U tot
1 18,236 18,236
17 20,37 346,29
5 6,318 31,59
</code></pre>

Call The function:

<pre><code>from_excel_to_list("""N U tot
1 18,236 18,236
17 20,37 346,29
5 6,318 31,59
""")
</code></pre>

Result in Jupiter:

<pre><code>[['N', 'U', 'tot'],
 ['1', '18,236', '18,236'],
 ['17', '20,37', '346,29'],
 ['5', '6,318', '31,59']]
</code></pre>

This is a base for further elaboration.
The same approach can be used to obtain dictionary, namedtuple and so on.

blocks|key|3108403|text|如果df.to_clipboard不能工作的话。这会管用的。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3108404|import+io
with+io.StringIO()+as+buffer:
++++df.to_csv(buffer,+sep='+',+index=False)
++++print(buffer.getvalue())|code-block|syntax|javascript|3108405|然后，您可以复制打印的数据，并将其粘贴到Excel或Google中。|3108406|entityMap^0|2|F|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|R|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|S|8|@]|D|@]|E|$]]|$1|M|3|-4|5|6|7|T|8|@]|D|@]|E|$]]]|N|$]]

If <code>df.to_clipboard</code> doesn't work. This will work.

<pre><code>import io
with io.StringIO() as buffer:
 df.to_csv(buffer, sep=' ', index=False)
 print(buffer.getvalue())
</code></pre>

Then, you can copy the printed dataframe and paste it in Excel or Google Sheets.

blocks|key|3108442|text|将输出粘贴到像Atom这样的IDE中，然后粘贴到/Excel中|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3108443|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Paste the output to an IDE like Atom and then paste in Google Sheets/Excel

blocks|key|3021172|text|​|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3021173|📷|atomic|offset|length|3021174|3021175|对于一个小表，您可以打印dataframe，使用鼠标选择表，使用Ctrl/Cmd+%2B+C复制表，转到电子表格并粘贴该表，您将得到以下内容：|3021176|3021177|3021178|单击第一个单元格并插入一个单元格以修复标头：|3021179|3021180|3021181|好了。|3021182|PS:对于更大的表，某些行/列将显示为“.”，请参考How+do+I+expand+the+output+display+to+see+more+columns+of+a+Pandas+DataFrame?以显示所有行和列。对于更大的表(这是很难选择使用鼠标)，这种方法不太方便。|3021183|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://developer.qcloudimg.com/http-save/yehe-900000/cdcb3845bdd7b909b818396a31cbd486.png|imageAlt|1|https://developer.qcloudimg.com/http-save/yehe-900000/48779056d4d91e9484fac5596555e66d.png|2|https://developer.qcloudimg.com/http-save/yehe-900000/1d5d1d47c62db071daa47f6cd8521630.png|3|LINK|MUTABLE|url|https://stackoverflow.com/questions/11707586/how-do-i-expand-the-output-display-to-see-more-columns-of-a-pandas-dataframe^0|0|0|1|0|0|0|0|0|1|1|0|0|0|0|1|2|0|0|0|Q|25|3|0^^$0|@$1|2|3|4|5|6|7|1B|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|1C|8|@]|9|@$E|1D|F|1E|1|1F]]|A|$]]|$1|G|3|4|5|6|7|1G|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|1H|8|@]|9|@]|A|$]]|$1|J|3|C|5|D|7|1I|8|@]|9|@$E|1J|F|1K|1|1L]]|A|$]]|$1|K|3|4|5|6|7|1M|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|1N|8|@]|9|@]|A|$]]|$1|N|3|C|5|D|7|1O|8|@]|9|@$E|1P|F|1Q|1|1R]]|A|$]]|$1|O|3|4|5|6|7|1S|8|@]|9|@]|A|$]]|$1|P|3|Q|5|6|7|1T|8|@]|9|@]|A|$]]|$1|R|3|S|5|6|7|1U|8|@]|9|@$E|1V|F|1W|1|1X]]|A|$]]|$1|T|3|-4|5|6|7|1Y|8|@]|9|@]|A|$]]]|U|$V|$5|W|X|Y|A|$Z|10|11|-4]]|12|$5|W|X|Y|A|$Z|13|11|-4]]|14|$5|W|X|Y|A|$Z|15|11|-4]]|16|$5|17|X|18|A|$19|1A]]]]

<a href="https://i.stack.imgur.com/q1CjV.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/q1CjV.png" alt="enter image description here" /></a>
For a small table, you can print the dataframe, use mouse to select the table, copy the table using Ctrl/Cmd + C, go to spreadsheet and paste the table, and you will get the following:
<a href="https://i.stack.imgur.com/iVrPr.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/iVrPr.png" alt="enter image description here" /></a>
click on the first cell and insert a cell to fix the header:
<a href="https://i.stack.imgur.com/U6YTm.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/U6YTm.png" alt="enter image description here" /></a>
Done.
PS: for a bigger table, some rows/columns will show as '...', refer to <a href="https://stackoverflow.com/questions/11707586/how-do-i-expand-the-output-display-to-see-more-columns-of-a-pandas-dataframe">How do I expand the output display to see more columns of a Pandas DataFrame?</a> to show all rows and columns. For a even bigger table (that is difficult to select using the mouse), this method is not so convenient.

blocks|key|3108610|text|我使用display()而不是print()，它对我来说很好。示例：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3108611|from+IPython.display+import+display
import+pandas+as+pd

dict+=+{'Name'+:+['Alice',+'Bob',+'Charlie'],
++++++++'English'+:+[73,+55,+90],
++++++++'Math'+:+[78,+100,+33],
++++++++'Geography'+:+[92,+87,+72]}

df+=+pd.DataFrame(dict)

display(df)|code-block|syntax|javascript|3108612|结果可以很容易地复制和粘贴到Excel中，格式也不会被弄乱。这种方法也适用于Colab。|3108613|entityMap^0|3|9|F|7|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]|$9|R|A|S|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|T|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|U|8|@]|D|@]|E|$]]|$1|M|3|-4|5|6|7|V|8|@]|D|@]|E|$]]]|N|$]]

I use <code>display()</code> instead of <code>print()</code> and it works fine for me. Example:
<pre><code>from IPython.display import display
import pandas as pd

dict = {'Name' : ['Alice', 'Bob', 'Charlie'],
 'English' : [73, 55, 90],
 'Math' : [78, 100, 33],
 'Geography' : [92, 87, 72]}

df = pd.DataFrame(dict)

display(df)
</code></pre>
The result can easily be copied and pasted into Excel and formatting won't be messed up. This method also works with Colab.

I've been using iPython (aka Jupyter) quite a bit lately for data analysis and some machine learning. But one big headache is copying results from the notebook app (browser) into either Excel or Google Sheets so I can manipulate results or share them with people who don't use iPython.

I know how to convert results to csv and save. But then I have to dig through my computer, open the results and paste them into Excel or Google Sheets. That takes too much time.

And just highlighting a resulting dataframe and copy/pasting usually completely messes up the formatting, with columns overflowing. (Not to mention the issue of long resulting dataframes being truncated when printed in iPython.)

How can I easily copy/paste an iPython result into a spreadsheet?

How to copy/paste a dataframe from iPython into Google Sheets or Excel?

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

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

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

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

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

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

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

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋 

腾讯云代码助手

CODING DevOps

Cloud Studio

SDK中心

API中心

命令行工具

最近，我一直在使用iPython (又名木星)进行数据分析和一些机器学习。但令人头疼的是，将笔记本应用程序(浏览器)的结果复制到Excel或Google中，这样我就可以操纵结果，或者与不使用iPython的人分享结果。我知道如何将结果转换为csv并保存。但是，我必须在我的计算机中挖掘，打开结果，并将它们粘贴到Excel...

问如何将数据从iPython复制/粘贴到Google或Excel中？
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何将数据从iPython复制/粘贴到Google或Excel中？EN