import pandas as pd
df = pd.read_csv(
filepath_or_buffer='C:/Users/think/Desktop/sz000002.csv',
sep=',',
skiprows = 1,
nrows = 10,
#parse_dates=['交易日期']
usecols =['交易日期','股票代码','股票名称','收盘价','涨跌幅','成交量','MACD_金叉死叉'],
error_bad_lines = False,
na_values='NULL',
)import pandas as pd
df = pd.read_csv(
filepath_or_buffer='C:/Users/think/Desktop/sz000002.csv',
sep=',',
skiprows = 1,
nrows = 10,
#parse_dates=['交易日期']
usecols =['交易日期','股票代码','股票名称','收盘价','涨跌幅','成交量','MACD_金叉死叉'],
error_bad_lines = False,
na_values='NULL',
)
print (df[(df.index >= '03/12/2016') & (df.index <= '06/12/2016')])
Traceback (most recent call last):
File "C:\Users\think\PycharmProjects\pythonProject2\main.py", line 29, in
print (df[(df.index >= '03/12/2016') & (df.index <= '06/12/2016')])
File "C:\Users\think\PycharmProjects\pythonProject2\venv\lib\site-packages\pandas\core\ops\common.py", line 69, in new_method
return method(self, other)
File "C:\Users\think\PycharmProjects\pythonProject2\venv\lib\site-packages\pandas\core\arraylike.py", line 52, in ge
return self._cmp_method(other, operator.ge)
File "C:\Users\think\PycharmProjects\pythonProject2\venv\lib\site-packages\pandas\core\indexes\range.py", line 879, in _cmp_method
return super()._cmp_method(other, op)
File "C:\Users\think\PycharmProjects\pythonProject2\venv\lib\site-packages\pandas\core\indexes\base.py", line 6061, in _cmp_method
result = ops.comparison_op(self._values, other, op)
File "C:\Users\think\PycharmProjects\pythonProject2\venv\lib\site-packages\pandas\core\ops\array_ops.py", line 281, in comparison_op
return invalid_comparison(lvalues, rvalues, op)
File "C:\Users\think\PycharmProjects\pythonProject2\venv\lib\site-packages\pandas\core\ops\invalid.py", line 34, in invalid_comparison
raise TypeError(f"Invalid comparison between dtype={left.dtype} and {typ}")
TypeError: Invalid comparison between dtype=int64 and str
Process finished with exit code 1
df.index >= '03/12/2016',df.index是数字,'03/12/2016'是字符串,不能比较大小