Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Using LINEST for non-linear curve fitting
- Downloads
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Cubic Splines
- Commenting a block of code in VBA
- Contour plots with Excel and Matplotlib
- Using Goal Seek on Multiple Cells
- Downloads by category
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
Recent Comments
Sukrit Ghorai on Biaxial bending update dougaj4 on Biaxial bending update Sukrit on Biaxial bending update A not so easy proble… on Pint, MPmath and implied units… dougaj4 on ULS design of circular reinfor… Dakota on ULS design of circular reinfor… Marcus747 on Commenting a block of code in… dougaj4 on Biaxial bending update Sukrit on Biaxial bending update DT67 on Using ConbeamU DT67 on Using ConbeamU dougaj4 on Using ConbeamU DT67 on Using ConbeamU DT67 on Using ConbeamU dougaj4 on Biaxial bending update
Tag Archives: dataseries
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