检索结果-南通市图书馆

Enhancing Data Analysis and Automation: Integrating Python with Microsoft Excel for Non-Programmers

Journal of Software Engineering and Applications 2024年第6期17卷 530-540页

作者： Osama Magdy Ali Mohamed Breik tarek Aly Atef Tayh Nour El-Din Raslan Mervat Gheith Software Engineering Department Faculty of Graduate Studies for Statistical Research Cairo University Giza Egypt

Microsoft Excel is essential for the End-User Approach (EUA), offering versatility in data organization, analysis, and visualization, as well as widespread accessibility. It fosters collaboration and informed decision-making across diverse domains. Conversely, Python is indispensable for professional programming due to its versatility, readability, extensive libraries, and robust community support. It enables efficient development, advanced data analysis, data mining, and automation, catering to diverse industries and applications. However, one primary issue when using Microsoft Excel with Python libraries is compatibility and interoperability. While Excel is a widely used tool for data storage and analysis, it may not seamlessly integrate with Python libraries, leading to challenges in reading and writing data, especially in complex or large datasets. Additionally, manipulating Excel files with Python may not always preserve formatting or formulas accurately, potentially affecting data integrity. Moreover, dependency on Excel’s graphical user interface (GUI) for automation can limit scalability and reproducibility compared to Python’s scripting capabilities. This paper covers the integration solution of empowering non-programmers to leverage Python’s capabilities within the familiar Excel environment. This enables users to perform advanced data analysis and automation tasks without requiring extensive programming knowledge. Based on Soliciting feedback from non-programmers who have tested the integration solution, the case study shows how the solution evaluates the ease of implementation, performance, and compatibility of Python with Excel versions.

关键词： Python End-User Approach Microsoft Excel Data Analysis Integration Spreadsheet Programming Data Visualization

来源：

维普期刊数据库评论

在线全文

维普期刊数据库

学校读者我要写书评

暂无评论

Building Custom Spreadsheet Functions with Python: End-User Software Engineering Approach

引用

Journal of Software Engineering and Applications 2024年第5期17卷 246-258页

作者： Tamer Bahgat Elserwy Atef Tayh Nour El-Din Raslan tarek Ali Mervat H. Gheith Department of Software Engineering Faculty of Graduate Studies for Statistical Research (FGSSR) Cairo University Giza Egypt Department of Information Systems Higher Institute of Advanced Studies Giza Egypt

End-user computing empowers non-developers to manage data and applications, enhancing collaboration and efficiency. Spreadsheets, a prime example of end-user programming environments widely used in business for data analysis. However, Excel functionalities have limits compared to dedicated programming languages. This paper addresses this gap by proposing a prototype for integrating Python’s capabilities into Excel through on-premises desktop to build custom spreadsheet functions with Python. This approach overcomes potential latency issues associated with cloud-based solutions. This prototype utilizes Excel-DNA and IronPython. Excel-DNA allows creating custom Python functions that seamlessly integrate with Excel’s calculation engine. IronPython enables the execution of these Python (CSFs) directly within Excel. C# and VSTO add-ins form the core components, facilitating communication between Python and Excel. This approach empowers users with a potentially open-ended set of Python (CSFs) for tasks like mathematical calculations, statistical analysis, and even predictive modeling, all within the familiar Excel interface. This prototype demonstrates smooth integration, allowing users to call Python (CSFs) just like standard Excel functions. This research contributes to enhancing spreadsheet capabilities for end-user programmers by leveraging Python’s power within Excel. Future research could explore expanding data analysis capabilities by expanding the (CSFs) functions for complex calculations, statistical analysis, data manipulation, and even external library integration. The possibility of integrating machine learning models through the (CSFs) functions within the familiar Excel environment.

关键词： End-User Software Engineering Custom Spreadsheet Functions (CSFs)

来源：

维普期刊数据库评论

在线全文

维普期刊数据库

学校读者我要写书评

暂无评论

An Improved Enterprise Resource Planning System Using Machine Learning Techniques

引用

Journal of Software Engineering and Applications 2024年第5期17卷 203-213页

作者： Ahmed Youssri Zakaria Elsayed Abdelbadea Atef Raslan tarek Ali Mervat Gheith Al-Sayed Khater Essam A. Amin Department of Software Engineering Faculty of Graduate Studies for Statistical Research (FGSSR) Cairo University Giza Egypt

Traditional Enterprise Resource Planning (ERP) systems with relational databases take weeks to deliver predictable insights instantly. The most accurate information is provided to companies to make the best decisions through advanced analytics that examine the past and the future and capture information about the present. Integrating machine learning (ML) into financial ERP systems offers several benefits, including increased accuracy, efficiency, and cost savings. Also, ERP systems are crucial in overseeing different aspects of Human Capital Management (HCM) in organizations. The performance of the staff draws the interest of the management. In particular, to guarantee that the proper employees are assigned to the convenient task at the suitable moment, train and qualify them, and build evaluation systems to follow up their performance and an attempt to maintain the potential talents of workers. Also, predicting employee salaries correctly is necessary for the efficient distribution of resources, retaining talent, and ensuring the success of the organization as a whole. Conventional ERP system salary forecasting methods typically use static reports that only show the system’s current state, without analyzing employee data or providing recommendations. We designed and enforced a prototype to define to apply ML algorithms on Oracle EBS data to enhance employee evaluation using real-time data directly from the ERP system. Based on measurements of accuracy, the Random Forest algorithm enhanced the performance of this system. This model offers an accuracy of 90% on the balanced dataset.

关键词： ERP HCM Machine Learning Employee Performance Pythonista Pythoneer

来源：

维普期刊数据库评论

在线全文

维普期刊数据库

学校读者我要写书评

暂无评论

The Effect of Core Eccentricity on the Structural Behavior of Concrete Tall Buildings

引用

Journal of Civil Engineering and Architecture 2024年第3期18卷 112-117页

作者： tarek Anwar Taha Awida Civil and Architecture Engineering Department College of EngineeringInternational University of Kuwait(IUK)Ardiya Government AreaKuwait

The main purpose of this paper is to investigate the effect of core eccentricity on the structural behavior of concrete tall *** buildings of 55 floors with plan dimensions 48.0×48.0 m2 were *** cases of main core locations are studied:centric(A),eccentric by one sixth(B)and one third(C)of building *** three-dimensional finite element method has been used in conducting structural analysis through ETABS *** and lateral(wind and seismic)loadings are applied to all building *** has been concluded that the core location is the prime parameter governing the structural behavior of tall *** the first two cases(A,B)have acceptable and similar structural behaviors conforming to code limits,in the third case(C),the building behavior came beyond code *** author introduced remedial action by adding two secondary cores in the opposite direction of the main core(C-R)to restore the building behavior to the code *** results of this action were satisfactory.

关键词： Concrete tall buildings core eccentricity structural behavior gravity wind seismic loadings

来源：

维普期刊数据库评论

在线全文

维普期刊数据库

学校读者我要写书评

暂无评论

Face Templates Encryption Technique Based on Random Projection and Deep Learning

引用

Computer Systems Science & Engineering 2023年第3期44卷 2049-2063页

作者： Mayada tarek Department of Computer Science Mansoura UniversityMansoura35516Egypt Department of Computer Science Jouf UniversityJouf2014KSA

Cancellable biometrics is the solution for the trade-off between two concepts:Biometrics for Security and Security for *** cancelable template is stored in the authentication system’s database rather than the original biometric *** case of the database is compromised,it is easy for the template to be canceled and regenerated from the same biometric *** of the cancelable template comes from the diversity of the cancelable transformation parameters(cancelable key).Therefore,the cancelable key must be secret to be used in the system authentication process as a second authentication factor in con-junction with the biometric *** main contribution of this paper is to tackle the risks of stolen/lost/shared cancelable keys by using biometric trait(in different feature domains)as the only authentication factor,in addition to achieving good performance with high *** standard Generative Adversarial Network(GAN)is proposed as an encryption tool that needs the cancelable key during the training phase,and the testing phase depends only on the biometric ***,random projection transformation is employed to increase the proposed system’s security and *** proposed transformation system is tested using the standard ORL face database,and the experiments are done by applying different features ***,a security analysis for the proposed transformation system is presented.

关键词： Cancelable biometrics(CBs) random projection ORL face database generative adversarial network(GAN)

来源：

维普期刊数据库评论

在线全文

维普期刊数据库

学校读者我要写书评

暂无评论

Energy-Efficient UAVs Coverage Path Planning Approach

引用

Computer Modeling in Engineering & Sciences 2023年第9期136卷 3239-3263页

作者： Gamil Ahmed tarek Sheltami Ashraf Mahmoud Ansar Yasar Computer Engineering Department Interdisciplinary Research Center of Smart Mobility and LogisticsKing Fahd University of Petroleum and MineralsDhahran31261Saudi Arabia Transportation Research Institute(IMOB) Hasselt UniversityHasselt3500Belgium

Unmanned aerial vehicles(UAVs),commonly known as drones,have drawn significant consideration thanks to their agility,mobility,and flexibility *** play a crucial role in modern reconnaissance,inspection,intelligence,and surveillance *** path planning(CPP)which is one of the crucial aspects that determines an intelligent system’s quality seeks an optimal trajectory to fully cover the region of interest(ROI).However,the flight time of the UAV is limited due to a battery limitation and may not cover the whole region,especially in large ***,energy consumption is one of the most challenging issues that need to be *** this paper,we propose an energy-efficient coverage path planning algorithm to solve the CPP *** objective is to generate a collision-free coverage path that minimizes the overall energy consumption and guarantees covering the whole *** do so,the flight path is optimized and the number of turns is reduced to minimize the energy *** proposed approach first decomposes the ROI into a set of cells depending on a UAV camera ***,the coverage path planning problem is formulated,where the exact solution is determined using the CPLEX *** small-scale problems,the CPLEX shows a better solution in a reasonable ***,the CPLEX solver fails to generate the solution within a reasonable time for large-scale ***,to solve the model for large-scale problems,simulated annealing forCPP is *** results show that heuristic approaches yield a better solution for large-scale problems within amuch shorter execution time than the CPLEX ***,we compare the simulated annealing against the greedy *** results show that simulated annealing outperforms the greedy algorithm in generating better solution quality.

关键词： Coverage path planning MILP CPLEX solver energy model optimization region of interest area of interest

来源：

维普期刊数据库评论

在线全文

维普期刊数据库

学校读者我要写书评

暂无评论

Editorial on“Laparoscopic versus open liver resection for hepatocellular carcinoma in elderly patients:a propensity score matching analysis”

引用

Hepatobiliary Surgery and Nutrition 2022年第4期11卷 580-582页

作者： Jean Gugenheim tarek Debs Department of Digestive Surgery and Liver Transplant Unit University Côte d’AzurCHU de NiceNiceFrance

We read with great interest the article of Delvecchio et *** in a recent issue of HPB journal(1).The authors compared short-and long-term outcomes of laparoscopic and open liver resection(OLR)in elderly patients with ... 详细信息

关键词： patients hepatocellular al.

来源：

维普期刊数据库评论

在线全文

维普期刊数据库

学校读者我要写书评

暂无评论

Review of analytical methods for stress and deformation analysis of buried water pipes considering pipe-soil interaction

引用

Underground Space 2023年第6期13卷 205-227页

作者： Yingxu Huo Sherif Mohsen Mohamed Hassan Gomaa tarek Zayed Mohamed Meguid Department of Civil and Environmental Engineering The Hong Kong Polytechnic UniversityHung HomHong Kong 999077China Department of Building and Real Estate The Hong Kong Polytechnic UniversityHung HomHong Kong 999077China Structural Engineering Department Faculty of EngineeringMansoura UniversityMansoura 35516Egypt Department of Civil Engineering McGill UniversityMontrealQuebec H3A 0G4Canada

Buried water pipelines are vulnerable to fail or break due to excessive loading or ground *** evaluation of pipe performance and serviceability relies on the proper understanding of pipe-soil interactions(PSI).Analytical methods are important approaches to studying ***,a systematic and thorough literature review to analyze the existing research trends,technological achievements and future research opportunities is not *** work investigates analytical methods that analyze the stress and deformation of pipes in terms of cross-sectional,transverse and longitudinal PSI ***,scientometric analysis is performed to acquire relevant research works from online databases and analyze the existing data of influential authors,productive research sources and frequent key word occurrence in the fields of ***,a qualitative discussion is performed in the three categories of PSI:(1)cross-sectional,including ovalization and circumferential behaviours;(2)transverse,including seismic fault crossing,weak soil zones,ground settlement and pipe uplift;and(3)***,six research opportunities are discussed,including the role of friction in cross-sectional deformation,combined effects of bending and compression,choice of soil reaction models and calibration of key parameters,effect of pipe flaws,soil spatial variability and behaviours of curved *** study helps beginners familiarize themselves with PSI analytical methods and provides experienced researchers with ideas for future research directions.

关键词： Pipeline Analytical methods Pipe-soil interactions Seismic fault Settlement Uplift Buckling Tunnelling

来源：

维普期刊数据库评论

在线全文

维普期刊数据库

学校读者我要写书评

暂无评论

Improving of photocatalytic activity of barium ferrate via bismuth and copper co-doping for degradation of paracetamol under visible light irradiation

引用

Journal of Environmental Sciences 2022年第2期34卷 331-342页

作者： Hussien Ahmed Abbas Rabab Ahmed Nasr Rose-Noelle Vannier tarek Samir Jamil Inorganic Chemistry Department National Research CentreCairo 12622Egypt Water Pollution Control Department National Research CenterCairo 12622Egypt Univ.Lille CNRSCentrale LilleENSCLUniv.ArtoisUMR 8181Unite de Catalyse et Chimie du Solide(UCCS)Lille 59000France

Nanosized Ba_(1-x)Bi_(x)Fe_(1-x)Cu_(x)O_(3)(12–50 nm)with x values of 0,0.01,0.05,and 0.1 system was prepared using the Pechini ***,morphological,surface and optical characterizations were performed for the prepared *** phase was the predominant phase for the undoped BaFeO_(3)and Bi and Cu co-doped BaFeO_(3)*** phases of monoclinic Ba_(2)Fe_(2)O_(5),orthorhombic BaFe_(2)O_(4)and orthorhombic BaCO_(3)were identified for all the prepared ***_(0.95)Bi_(0.05)Fe_(0.95)Cu_(0.05)O_(3)sample has the lowest band gap(2.43 e V).98.1%paracetamol removal was achieved with 0.75 g/L of Ba_(0.95)Bi_(0.05)Fe_(0.95)Cu_(0.05)O_(3)at pH9 after 120 *** paracetamol degradation follows the pseudo first-order ***·is the main oxidative species responsible for the paracetamol *** chromatography–mass spectrometry(GC–MS)analysis was performed at the end of the photocatalytic degradation experiment under optimum operating condition using Ba_(0.95)Bi_(0.05)Fe_(0.95)Cu_(0.05)O_(3)to explain the reaction mechanism and identify the intermediate by-products which is confirmed by ultraviolet/visible(UV/Vis)spectroscopy study at different reaction times.

关键词： Ba_(1-x)Bi_(x)Fe_(1-x)Cu_(x)O_(3) Photocatalytic degradation Nanomaterials Paracetamol

来源：

维普期刊数据库

同方期刊数据库评论

在线全文

学校读者我要写书评

暂无评论

Impact Assessment and Mitigation Techniques for High Penetration Levels of Renewable Energy Sources in Distribution Networks:Voltage-control Perspective

引用

Journal of Modern Power Systems and Clean Energy 2022年第2期10卷 450-458页

作者： Ahmed S.A.Awad Dave Turcotte tarek H.M.El-Fouly Natural Resources Canada Can-metENERGYVarennesCanadaon leave from the Electrical Power and Machines DepartmentFaculty of EngineeringAin Shams UniversityCairo 11566Egyp Natural Resources Canada CanmetENERGYVarennesCanada Advanced Power and Energy Center Khalifa UniversityAbu DhabiUnited Arab Emirates

The integration of renewable distributed generation(RDG)into distribution networks is promising and increasing ***,high penetration levels of distributed generation(DG)are often limited as they may have an adverse effect on the operation of distribution *** of the operation challenges is the interaction between DG and voltage-control equipment,e.g.,an under-load tap changer(ULTC),which is basically designed to compensate for voltage changes caused by slow load *** integration of variable DGs leads to rapid voltage fluctuations,which can negatively affect the tap operation of *** paper investigates the impact of high penetration levels of RDG on the tap operation of ULTC in distribution networks through *** mitigation techniques that can alleviate this impact are also *** these techniques,constant power-factor mode is regarded as the best trade-off between the simplicity and effectiveness of minimizing the number of tap *** are performed on a Canadian benchmark rural distribution feeder using OpenDSS software.

关键词： Renewable energy distributed generation(DG) voltage regulator load tap changer distribution network.

来源：

维普期刊数据库

同方期刊数据库评论

在线全文

学校读者我要写书评

暂无评论

欢迎您,

建议与咨询留下您的常用邮箱和电话号码，以便我们向您反馈解决方案和替代方法

时间限定

文献类型

馆藏选择

核心期刊

语言

文献类型

帮助

文字说明：

检索规则说明：

检索范例：

分类表

所选分类

限定检索结果

文献类型

馆藏范围

日期分布

学科分类号

主题

机构

作者

语言

在线全文

在线全文

在线全文

在线全文

在线全文

在线全文

在线全文

在线全文

在线全文

在线全文

请选择保存的检索档案：

请选择收藏分类：

通借通还

欢迎您,

建议与咨询 留下您的常用邮箱和电话号码，以便我们向您反馈解决方案和替代方法

时间限定

文献类型

馆藏选择

核心期刊

语言

文献类型

帮助

文字说明：

检索规则说明：

检索范例：

分类表

所选分类

限定检索结果

文献类型

馆藏范围

日期分布

学科分类号

主题

机构

作者

语言

在线全文

在线全文

在线全文

在线全文

在线全文

在线全文

在线全文

在线全文

在线全文

在线全文

请选择保存的检索档案： 新增检索档案 确定 取消

请选择收藏分类： 新增自定义分类 确定 取消

通借通还

建议与咨询留下您的常用邮箱和电话号码，以便我们向您反馈解决方案和替代方法

请选择保存的检索档案：

请选择收藏分类：