65830

ValueError: The truth value of a DataFrame is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or

Question:

I try to forward a data to excel but received the subject error.

I want to combine some of excel files into one excel file. First I created all_info array in order to collect all data into.

all_info = []

After that I read every excel files. Excel files follows; sample1, sample2, and so on.

data = pd.read_excel('sample1.xlsx', 'Sheet1')

I add each excel files' data into all_info array with below.

for i in range(0, len(data)): all_info.append(data)

After I combine all data within all_info array, I executed below code but received the subject error.

df = pd.DataFrame(all_info) df.to_excel("all_info.xlsx")

You may see error details below.

ValueError Traceback (most recent call last) <ipython-input-85-5bff7d788042> in <module>() 1 df = pd.DataFrame(all_tweets) ----> 2 df.to_excel("all_info.xlsx") /usr/lib/python2.7/dist-packages/pandas/core/frame.pyc in to_excel(self, excel_writer, sheet_name, na_rep, float_format, cols, header, index, index_label, startrow, startcol, engine, merge_cells) 1202 formatted_cells = formatter.get_formatted_cells() 1203 excel_writer.write_cells(formatted_cells, sheet_name, -> 1204 startrow=startrow, startcol=startcol) 1205 if need_save: 1206 excel_writer.save() /usr/lib/python2.7/dist-packages/pandas/io/excel.pyc in write_cells(self, cells, sheet_name, startrow, startcol) 525 colletter = get_column_letter(startcol + cell.col + 1) 526 xcell = wks.cell("%s%s" % (colletter, startrow + cell.row + 1)) --> 527 xcell.value = _conv_value(cell.val) 528 style = None 529 if cell.style: /usr/lib/pymodules/python2.7/openpyxl/cell.pyc in _set_value(self, value) 339 def _set_value(self, value): 340 """Set the value and infer type and display options.""" --> 341 self.bind_value(value) 342 343 value = property(_get_value, _set_value, /usr/lib/pymodules/python2.7/openpyxl/cell.pyc in bind_value(self, value) 278 def bind_value(self, value): 279 """Given a value, infer type and display options.""" --> 280 self._data_type = self.data_type_for_value(value) 281 if value is None: 282 self.set_value_explicit('', self.TYPE_NULL) /usr/lib/pymodules/python2.7/openpyxl/cell.pyc in data_type_for_value(self, value) 260 elif isinstance(value, (datetime.datetime, datetime.date, datetime.time, datetime.timedelta)): 261 data_type = self.TYPE_NUMERIC --> 262 elif not value: 263 data_type = self.TYPE_STRING 264 elif isinstance(value, basestring) and value[0] == '=': /usr/lib/python2.7/dist-packages/pandas/core/generic.pyc in __nonzero__(self) 674 raise ValueError("The truth value of a {0} is ambiguous. " 675 "Use a.empty, a.bool(), a.item(), a.any() or a.all()." --> 676 .format(self.__class__.__name__)) 677 678 __bool__ = __nonzero__ ValueError: The truth value of a DataFrame is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all().

Answer1:

Do you maybe want to do something like this?

fnames = ['sample1.xls', 'sample2.xls'] all_info = [pd.read_excel(f, 'Sheet1') for f in fnames] df = pd.concat(all_info) df.to_excel("all_info.xlsx")

Here, all_info is a list of DataFrames, where each elements is holding the different Excel Data. Then they are concatenated into one DataFrame and saved to disk...

Recommend

  • Can't install scipy
  • iPython Notebook not printing Dataframe as table
  • Executing a function that adds columns and populates them dependig on other columns in Pandas
  • Parsing Data From Long to Wide Format in Python
  • Importing pyplot in a Jupyter Notebook
  • Python 2.7 on OS X: TypeError: 'frozenset' object is not callable on each command
  • How to set a thread specific environment variable in Python?
  • Pandas groupby to to_csv
  • Using Netbeans with Cygwin and SDL, including SDL.h creates strange error
  • Get the last date of each month in a list of dates in Python
  • CS1703: In Xamarin.Droid, should I use the .Net Standard windowsruntime.dll located in Mono.Framewor
  • Python adding lots of things to PATH. How do I stop?
  • How do I change the kernel/python version for iPython?
  • user data scripts fails without giving reason
  • Interpreting STRACE output - pipes and forks
  • Python 3.2.2, error(scripts to exe)
  • PHP Listener Script for Paypal Webhooks
  • Write output of for loop to multiple files
  • php script is parsing content from RTE (tt_news) but internal links are not appearing as speaking ur
  • Error in installing package: fatal error: stdlib.h: no such file or directory
  • How to get latest version of a artifact on Bintray using JSONP
  • During installation of Django, why do I keep getting ImportError: No module named django?
  • pillow imaging ImportError
  • Angular2 component view does not update on value change via method
  • cygwin cannot exec 'git-add--interactive' permission denied
  • CakePHP ACL tutorial initDB function warnings
  • Problems installing Yesod for Haskell
  • wxPython: displaying multiple widgets in same frame
  • error importing numpy
  • Very simple C++ DLL that can be called from .net
  • R - Combining Columns to String Based on Logical Match
  • Java Scanner input dilemma. Automatically inputs without allowing user to type
  • Cross-Platform Protobuf Serialization
  • what is the difference between the asp.net mvc application and asp.net web application
  • SetUp method failed while running tests from teamcity
  • Matrix multiplication with MKL
  • Understanding cpu registers
  • embed rChart in Markdown
  • Binding checkboxes to object values in AngularJs
  • Unable to use reactive element in my shiny app