excel-filter

一个基于 Electron 和 Vue 的 Excel 数据过滤工具——凹凸实验室出品 https://aotu.io/notes/2016/11/15/xcel/

demo version

Data Analysis of Mandalle Restaurant with respect to different factors.

Data Analysis of 200 trips of Travel Times Pvt. Ltd.

By default, we have send query as take 1000 to get the filter check list. If you want to show all records instead of 1000 then use select query for getting current and previous filter records only

Prediction model for Delivery Time by Simple Linear Regression

Excel is an important tool in the field of Data Science. It provides us with so many formulas and makes our time consuming and complicated calculations easy. So, here are some questions based on formulas like Sum, Sumif, Sumifs, Count, Countif, Countifs.

Excel has now become an important part of our professional as well as personal life because it can use easily and it provides many functions in one single tool. Here is another assignment based on very important, very interesting and very attractive feature i.e. Pivot Table and Pivot Charts.

We all know the magic of Excel, hence, using this tool the most. Here are another few assignments with another important formulas of Excel called VOOKUP, IF, IFERROR, AND, OR, IFS and IFNA.

Remove the empty rows from data table but without looping.

Prediction model for Salary Hike by Simple Linear Regression