求助:涉及到for循环的concat如何使用

import pandas as pd
df = pd.DataFrame()
url_list = ['http://www.espn.com/nba/salaries/_/seasontype/4']
for i in range(2, 13):
url = 'http://www.espn.com/nba/salaries/_/page/%s/seasontype/4' % i
url_list.append(url)
#遍历网页中的table读取网页表格数据
for url in url_list:
df = df.append(pd.read_html(url), ignore_index=True)
#列表解析:遍历dataframe第3列,以子字符串$开头
df = df[[x.startswith('$') for x in df[3]]]
print(df)
df.to_csv('NBA.csv',header=['RK','NAME','TEAM','SALARY'], index=False)
运行后出错,提示如下:
D:\Python\pythonProject\venv\Scripts\python.exe "D:/Admin/Python数据分析从入门到精通/1. 示例源码--Python数据分析从入门到精通/03/18/demo.py"
D:\Admin\Python数据分析从入门到精通\1. 示例源码--Python数据分析从入门到精通\03\18\demo.py:9: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
df = df.append(pd.read_html(url), ignore_index=True)
D:\Admin\Python数据分析从入门到精通\1. 示例源码--Python数据分析从入门到精通\03\18\demo.py:9: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
df = df.append(pd.read_html(url), ignore_index=True)
D:\Admin\Python数据分析从入门到精通\1. 示例源码--Python数据分析从入门到精通\03\18\demo.py:9: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
df = df.append(pd.read_html(url), ignore_index=True)
D:\Admin\Python数据分析从入门到精通\1. 示例源码--Python数据分析从入门到精通\03\18\demo.py:9: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
df = df.append(pd.read_html(url), ignore_index=True)
D:\Admin\Python数据分析从入门到精通\1. 示例源码--Python数据分析从入门到精通\03\18\demo.py:9: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
df = df.append(pd.read_html(url), ignore_index=True)
D:\Admin\Python数据分析从入门到精通\1. 示例源码--Python数据分析从入门到精通\03\18\demo.py:9: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
df = df.append(pd.read_html(url), ignore_index=True)
D:\Admin\Python数据分析从入门到精通\1. 示例源码--Python数据分析从入门到精通\03\18\demo.py:9: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
df = df.append(pd.read_html(url), ignore_index=True)
D:\Admin\Python数据分析从入门到精通\1. 示例源码--Python数据分析从入门到精通\03\18\demo.py:9: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
df = df.append(pd.read_html(url), ignore_index=True)
D:\Admin\Python数据分析从入门到精通\1. 示例源码--Python数据分析从入门到精通\03\18\demo.py:9: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
df = df.append(pd.read_html(url), ignore_index=True)
D:\Admin\Python数据分析从入门到精通\1. 示例源码--Python数据分析从入门到精通\03\18\demo.py:9: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
df = df.append(pd.read_html(url), ignore_index=True)
D:\Admin\Python数据分析从入门到精通\1. 示例源码--Python数据分析从入门到精通\03\18\demo.py:9: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
df = df.append(pd.read_html(url), ignore_index=True)
D:\Admin\Python数据分析从入门到精通\1. 示例源码--Python数据分析从入门到精通\03\18\demo.py:9: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
df = df.append(pd.read_html(url), ignore_index=True)
Empty DataFrame
Columns: [0, 1, 2, 3]
Index: []
相关推荐
for循环中如何正确使用字符串拼接
众所周知,常见的拼接方式有:StringBuffer,StringBuilder,concat,+,StringUtils.join 那么通过如下代码,看一下在for循环中,不同的字符串拼接方式,到底哪种效率最高? package com.test.stringjoin; import org.apache.commons.lang3.StringUtils; public class Test { public static void main(String[] args) { long t1 = System.currentTimeMillis();
Mysql的GROUP_CONCAT()函数使用方法
语法: GROUP_CONCAT([DISTINCT] expr [,expr …][ORDER BY {unsigned_integer | col_name | expr}[ASC | DESC] [,col_name …]][SEPARATOR str_val]) 下面演示一下这个函数,先建立一个学生选课表student_courses,并填充一些测试数据。 SQL代码 复制代码 代码如下:CREATE TABLE student_courses ( student_id INT UNSIGNED NOT NULL, courses_id INT UN
MySQL中的CONCAT函数使用教程
使用MySQL CONCAT()函数将两个字符串连接起来,形成一个单一的字符串。试试下面的例子: mysql> SELECT CONCAT('FIRST ', 'SECOND'); +----------------------------+ | CONCAT('FIRST ', 'SECOND') | +----------------------------+ | FIRST SECOND | +----------------------------+ 1 row in set (0.00 sec) 了解CONCAT函数更详细,考虑EMPLOYEE_TBL表具有以下记录
java中concat()方法的使用说明
主要介绍了java中concat()方法的使用说明,具有很好的参考价值,希望对大家有所帮助。一起跟随小编过来看看吧
44_特征融合concat和add的区别1
1. 做的是对应通道对应位置的值的相加,通道数不变 2. 描述图像的特征个数不变,但是每个特征下的信息却增加了 1. 做的是通道的合并,通道数变多了 2. 描述



