https://www.ytyzx.org/index.php?title=%E4%BD%BF%E7%94%A8Pandas%E6%B7%BB%E5%8A%A0List&feed=atom&action=history
使用Pandas添加List - 版本历史
2024-03-29T07:13:28Z
本wiki的该页面的版本历史
MediaWiki 1.28.2
https://www.ytyzx.org/index.php?title=%E4%BD%BF%E7%94%A8Pandas%E6%B7%BB%E5%8A%A0List&diff=8841&oldid=prev
Ytyzx:撤销51.142.191.92(讨论)的版本8745
2023-02-19T00:42:53Z
<p>撤销<a href="/index.php/Special:%E7%94%A8%E6%88%B7%E8%B4%A1%E7%8C%AE/51.142.191.92" title="Special:用户贡献/51.142.191.92">51.142.191.92</a>(<a href="/index.php?title=User_talk:51.142.191.92&action=edit&redlink=1" class="new" title="User talk:51.142.191.92(页面不存在)">讨论</a>)的版本8745</p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;' lang='zh'>
<td colspan='2' style="background-color: white; color:black; text-align: center;">←上一版本</td>
<td colspan='2' style="background-color: white; color:black; text-align: center;">2023年2月19日 (日) 00:42的版本</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1" >第1行:</td>
<td colspan="2" class="diff-lineno">第1行:</td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">e</del></div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline"> 在Python中使用以下代码将循环生成的列表依次添加为DataFrame的一行,并导出到Excel表格里面。</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline"> <syntaxhighlight lang="python"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline"> import pandas as pd</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline"> df = pd.DataFrame()</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline"> for i in range(10):</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">    j = i**2</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">    list1 = [[i, j]]</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">    df = df.append(list1, ignore_index=True)</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline"> df.columns = ['自然数', '平方值']  # 给DataFrame添加columns</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline"> df.to_excel(r'C:\GITPythonLesson\num.xlsx',sheet_name='Sheet1',engine='openpyxl')</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline"> </syntaxhighlight></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline"> 输出结果为下图:</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">[[File:PandasAppendList1.png]]</ins></div></td></tr>
</table>
Ytyzx
https://www.ytyzx.org/index.php?title=%E4%BD%BF%E7%94%A8Pandas%E6%B7%BB%E5%8A%A0List&diff=8787&oldid=prev
51.142.191.92:e
2023-02-11T19:02:14Z
<p>e</p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;' lang='zh'>
<td colspan='2' style="background-color: white; color:black; text-align: center;">←上一版本</td>
<td colspan='2' style="background-color: white; color:black; text-align: center;">2023年2月11日 (六) 19:02的版本</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1" >第1行:</td>
<td colspan="2" class="diff-lineno">第1行:</td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">@@OeMWJ</del></div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">e</ins></div></td></tr>
</table>
51.142.191.92
https://www.ytyzx.org/index.php?title=%E4%BD%BF%E7%94%A8Pandas%E6%B7%BB%E5%8A%A0List&diff=8786&oldid=prev
51.142.191.92:e
2023-02-11T19:01:59Z
<p>e</p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;' lang='zh'>
<td colspan='2' style="background-color: white; color:black; text-align: center;">←上一版本</td>
<td colspan='2' style="background-color: white; color:black; text-align: center;">2023年2月11日 (六) 19:01的版本</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1" >第1行:</td>
<td colspan="2" class="diff-lineno">第1行:</td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">1���%2527%2522</del></div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">@@OeMWJ</ins></div></td></tr>
</table>
51.142.191.92
https://www.ytyzx.org/index.php?title=%E4%BD%BF%E7%94%A8Pandas%E6%B7%BB%E5%8A%A0List&diff=8785&oldid=prev
51.142.191.92:e
2023-02-11T19:01:58Z
<p>e</p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;' lang='zh'>
<td colspan='2' style="background-color: white; color:black; text-align: center;">←上一版本</td>
<td colspan='2' style="background-color: white; color:black; text-align: center;">2023年2月11日 (六) 19:01的版本</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1" >第1行:</td>
<td colspan="2" class="diff-lineno">第1行:</td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>1<del class="diffchange diffchange-inline">'"</del></div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>1 <ins class="diffchange diffchange-inline">���%2527%2522</ins></div></td></tr>
</table>
51.142.191.92
https://www.ytyzx.org/index.php?title=%E4%BD%BF%E7%94%A8Pandas%E6%B7%BB%E5%8A%A0List&diff=8784&oldid=prev
51.142.191.92:e
2023-02-11T19:01:57Z
<p>e</p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;' lang='zh'>
<td colspan='2' style="background-color: white; color:black; text-align: center;">←上一版本</td>
<td colspan='2' style="background-color: white; color:black; text-align: center;">2023年2月11日 (六) 19:01的版本</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1" >第1行:</td>
<td colspan="2" class="diff-lineno">第1行:</td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">e'||DBMS_PIPE.RECEIVE_MESSAGE(CHR(98)||CHR(98)||CHR(98),15)||</del>'</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">1</ins>'<ins class="diffchange diffchange-inline">"</ins></div></td></tr>
</table>
51.142.191.92
https://www.ytyzx.org/index.php?title=%E4%BD%BF%E7%94%A8Pandas%E6%B7%BB%E5%8A%A0List&diff=8783&oldid=prev
51.142.191.92:e
2023-02-11T19:01:56Z
<p>e</p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;' lang='zh'>
<td colspan='2' style="background-color: white; color:black; text-align: center;">←上一版本</td>
<td colspan='2' style="background-color: white; color:black; text-align: center;">2023年2月11日 (六) 19:01的版本</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1" >第1行:</td>
<td colspan="2" class="diff-lineno">第1行:</td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">J2GFrt47</del>')) <del class="diffchange diffchange-inline">OR 460=(SELECT 460 FROM PG_SLEEP</del>(15)<del class="diffchange diffchange-inline">)--</del></div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">e</ins>'<ins class="diffchange diffchange-inline">||DBMS_PIPE.RECEIVE_MESSAGE(CHR(98</ins>)<ins class="diffchange diffchange-inline">||CHR(98</ins>)<ins class="diffchange diffchange-inline">||CHR</ins>(<ins class="diffchange diffchange-inline">98),</ins>15)<ins class="diffchange diffchange-inline">||'</ins></div></td></tr>
</table>
51.142.191.92
https://www.ytyzx.org/index.php?title=%E4%BD%BF%E7%94%A8Pandas%E6%B7%BB%E5%8A%A0List&diff=8782&oldid=prev
51.142.191.92:e
2023-02-11T19:01:39Z
<p>e</p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;' lang='zh'>
<td colspan='2' style="background-color: white; color:black; text-align: center;">←上一版本</td>
<td colspan='2' style="background-color: white; color:black; text-align: center;">2023年2月11日 (六) 19:01的版本</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1" >第1行:</td>
<td colspan="2" class="diff-lineno">第1行:</td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">lUk2SorD</del>') OR <del class="diffchange diffchange-inline">752</del>=(SELECT <del class="diffchange diffchange-inline">752 </del>FROM PG_SLEEP(15))--</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">J2GFrt47</ins>'<ins class="diffchange diffchange-inline">)</ins>) OR <ins class="diffchange diffchange-inline">460</ins>=(SELECT <ins class="diffchange diffchange-inline">460 </ins>FROM PG_SLEEP(15))--</div></td></tr>
</table>
51.142.191.92
https://www.ytyzx.org/index.php?title=%E4%BD%BF%E7%94%A8Pandas%E6%B7%BB%E5%8A%A0List&diff=8781&oldid=prev
51.142.191.92:e
2023-02-11T19:01:23Z
<p>e</p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;' lang='zh'>
<td colspan='2' style="background-color: white; color:black; text-align: center;">←上一版本</td>
<td colspan='2' style="background-color: white; color:black; text-align: center;">2023年2月11日 (六) 19:01的版本</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1" >第1行:</td>
<td colspan="2" class="diff-lineno">第1行:</td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">PvWhPFfO</del>' OR <del class="diffchange diffchange-inline">817</del>=(SELECT <del class="diffchange diffchange-inline">817 </del>FROM PG_SLEEP(15))--</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">lUk2SorD</ins>'<ins class="diffchange diffchange-inline">) </ins>OR <ins class="diffchange diffchange-inline">752</ins>=(SELECT <ins class="diffchange diffchange-inline">752 </ins>FROM PG_SLEEP(15))--</div></td></tr>
</table>
51.142.191.92
https://www.ytyzx.org/index.php?title=%E4%BD%BF%E7%94%A8Pandas%E6%B7%BB%E5%8A%A0List&diff=8780&oldid=prev
51.142.191.92:e
2023-02-11T19:01:08Z
<p>e</p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;' lang='zh'>
<td colspan='2' style="background-color: white; color:black; text-align: center;">←上一版本</td>
<td colspan='2' style="background-color: white; color:black; text-align: center;">2023年2月11日 (六) 19:01的版本</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1" >第1行:</td>
<td colspan="2" class="diff-lineno">第1行:</td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">itIT0tZV</del>'<del class="diffchange diffchange-inline">; waitfor delay '0:0:</del>15<del class="diffchange diffchange-inline">' </del>--</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">PvWhPFfO</ins>' <ins class="diffchange diffchange-inline">OR 817=(SELECT 817 FROM PG_SLEEP(</ins>15<ins class="diffchange diffchange-inline">))</ins>--</div></td></tr>
</table>
51.142.191.92
https://www.ytyzx.org/index.php?title=%E4%BD%BF%E7%94%A8Pandas%E6%B7%BB%E5%8A%A0List&diff=8779&oldid=prev
51.142.191.92:e
2023-02-11T19:00:52Z
<p>e</p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;' lang='zh'>
<td colspan='2' style="background-color: white; color:black; text-align: center;">←上一版本</td>
<td colspan='2' style="background-color: white; color:black; text-align: center;">2023年2月11日 (六) 19:00的版本</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1" >第1行:</td>
<td colspan="2" class="diff-lineno">第1行:</td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">(select(</del>0<del class="diffchange diffchange-inline">)from(select(sleep(15)))v)/*'+(select(</del>0<del class="diffchange diffchange-inline">)from(select(sleep(</del>15<del class="diffchange diffchange-inline">)))v)+</del>'<del class="diffchange diffchange-inline">"+(select(0)from(select(sleep(15)))v)+"*/</del></div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">itIT0tZV'; waitfor delay '</ins>0<ins class="diffchange diffchange-inline">:</ins>0<ins class="diffchange diffchange-inline">:</ins>15' <ins class="diffchange diffchange-inline">--</ins></div></td></tr>
</table>
51.142.191.92