Python for Finance: Analyze Big Financial Data

generally most useful when seen as diachronic — i.e., in the sense that new data revealed over time ...

essentially the same. Note, though, that the computational burden increases substantially since we have to ...

because the respective graphical results are easier to understand and interpret (they are visually “more appealin ...

Conclusions Statistics is not only an important discipline in its own right, but also provides indispensible tools ...

Further Reading The following online resources are helpful: Information about the SciPy statistical functions i ...

Chapter 12. Excel Integration Microsoft Excel is probably the most successful data analytics platform of ...

developed more as a general graphical user interface (GUI) “only.” In many cases, it is mainly used to ...

Basic Spreadsheet Interaction Fundamental Python libraries to work with Excel spreadsheet files are xlrd a ...

This way, the sample data can be written “in bulk” to the two Worksheet objects: In [ 11 ]: for c in range(data. ...

Figure 12-1. Screenshot of workbook in Excel xlsxwriter has many more options to generate Workbook objec ...

Figure 12-2. Screenshot of workbook in Excel with a chart Reading from Workbooks The sister library xlr ...

columns and rows, respectively, that contain data: In [ 24 ]: sheet_1.ncols, sheet_1.nrows Out[24]: (8, 8) Single ...

Out[28]: [number:4.0, number:12.0, number:20. ...

In [ 39 ]: cell = ws[‘B4’] In [ 40 ]: cell.column Out[40]: ‘B’ In [ 41 ]: cell.row Out[41]: 4 In [ 42 ]: cell.val ...

In [ 49 ]: df_1.columns = columns df_2.columns = columns Indeed, the output of the two DataFrame objects now r ...

Figure 12-3. Screenshot of workbook in Excel written with pandas As a final use case for pandas and Exce ...

-rw––- 1 yhilpisch 16000080 Sep 28 18:20 data/data.npy ...

Scripting Excel with Python The previous section shows how to generate, read, and manipulate Excel spread ...

With this method, you control Excel spreadsheets via Python scripts, similar to the approach presented in th ...

In [ 4 ]: Cell(“B1”).value Out[ 4 ]: u’Excel with Python’ In the same way as you change the value attribute of ...