Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Commenting a block of code in VBA
- Using LINEST for non-linear curve fitting
- Arrays vs Collections vs Dictionary Objects (and Dictionary help)
- Using Goal Seek on Multiple Cells
- Retrieving unique values from a range or array ...
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Cubic Splines
- Beam actions and deflections by Macaulay's Method
Recent Comments
Benata on Ana Vidović mindOnion on Drawing a Buckyball in Ex… dougaj4 on Drawing a Buckyball in Ex… mindOnion on Drawing a Buckyball in Ex… mindOnion on Drawing in Excel 7 – Cre… Veronica Davenport on Asymmetric Catenary Function py_UMom spreadsheet… on More on combined shear and ben… Skip on xlwings – dataframes and… dougaj4 on xlwings – dataframes and… More on combined she… on RC Design Functions 9.03; comp… skip on xlwings – dataframes and… skip on mpmath for Excel dougaj4 on mpmath for Excel skip on mpmath for Excel dougaj4 on Composite Beam Spreadsheet Upd…
Tag Archives: Pandas
xlwSciPy 1.7
Following recent posts on xlwings 0.7.1, dictionaries, and optional arguments and xlwings – dataframes and statistics, I have added the associated functions and examples to the xlwSciPy spreadsheet, and also updated it to xlwings 0.71. The new spreadsheet can be … Continue reading
Posted in Excel, Link to Python, Maths, Newton, NumPy and SciPy, Python Pandas, UDFs, VBA
Tagged dataframes, dictionaries, Excel, Numpy, Pandas, Python, SciPy, UDF, VBA
4 Comments
xlwings – dataframes and statistics
Another data conversion option offered by the latest xlwings release is Pandas dataframes and dataseries. This post will look at how to pass an Excel range as a dataframe or dataseries in a User Defined Function (UDF), and some simple … Continue reading
Posted in Excel, Link to Python, Maths, Newton, Python Pandas, UDFs, VBA
Tagged dataframes, dataseries, Excel, Pandas, Python, statistics, UDF, VBA
4 Comments