python中列_Python中的列选择

---------------------------------------------------------------------------ValueErrorTraceback(most recent call last)C:\Users\Ruchir_Kumar_Jha\AppData\Local\Enthought\Canopy\edm\envs\User\lib\site-packages\pandas\core\common.pyin_asarray_tuplesafe(values,dtype)376result=np.empty(len(values),dtype=object)-->377result[:]=values378exceptValueError:ValueError:couldnotbroadcast input arrayfromshape(31807,0)into shape(31807)Duringhandling of the above exception,another exception occurred:ValueErrorTraceback(most recent call last)C:\Users\Ruchir_Kumar_Jha\AppData\Local\Enthought\Canopy\edm\envs\User\lib\site-packages\pandas\core\frame.pyin_ensure_valid_index(self,value)2375try:->2376value=Series(value)2377except:C:\Users\Ruchir_Kumar_Jha\AppData\Local\Enthought\Canopy\edm\envs\User\lib\site-packages\pandas\core\series.pyin__init__(self,data,index,dtype,name,copy,fastpath)247data=_sanitize_array(data,index,dtype,copy,-->248raise_cast_failure=True)249C:\Users\Ruchir_Kumar_Jha\AppData\Local\Enthought\Canopy\edm\envs\User\lib\site-packages\pandas\core\series.pyin_sanitize_array(data,index,dtype,copy,raise_cast_failure)3028else:->3029subarr=_asarray_tuplesafe(data,dtype=dtype)3030C:\Users\Ruchir_Kumar_Jha\AppData\Local\Enthought\Canopy\edm\envs\User\lib\site-packages\pandas\core\common.pyin_asarray_tuplesafe(values,dtype)379# we have a list-of-list-->380result[:]=[tuple(x)forxinvalues]381ValueError:cannot copy sequencewithsize0to array axiswithdimension31807Duringhandling of the above exception,another exception occurred:ValueErrorTraceback(most recent call last)in()11df.columns=df.columns.str.upper()12#print(list(df.columns))--->13df1['Isbn']=df[df.columns[df.columns.str.contains('|'.join(searchfor))]]14df1['Title']=df[df.columns[df.columns.to_series().str.contains('|'.join(searchfor1))]]15df1['Curr']=df[df.columns[df.columns.to_series().str.contains('|'.join(searchfor2))]]C:\Users\Ruchir_Kumar_Jha\AppData\Local\Enthought\Canopy\edm\envs\User\lib\site-packages\pandas\core\frame.pyin__setitem__(self,key,value)2329else:2330# set column->2331self._set_item(key,value)23322333def_setitem_slice(self,key,value):C:\Users\Ruchir_Kumar_Jha\AppData\Local\Enthought\Canopy\edm\envs\User\lib\site-packages\pandas\core\frame.pyin_set_item(self,key,value)2394""" 2395

-> 2396 self._ensure_valid_index(value) 2397 value = self._sanitize_column(key, value) 2398 NDFrame._set_item(self, key, value)

C:\Users\Ruchir_Kumar_Jha\AppData\Local\Enthought\Canopy\edm\envs\User\lib\site-packages\pandas\core\frame.py in _ensure_valid_index(self, value) 2376 value = Series(value) 2377 except:

-> 2378 raise ValueError('Cannot set a frame with no defined index ' 2379 'and a value that cannot be converted to a ' 2380 'Series')

ValueError: Cannot set a frame with no defined index and a value that cannot be converted to a Series