检索结果-南通市图书馆

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

来源：

维普期刊数据库评论

在线全文

维普期刊数据库

学校读者我要写书评

暂无评论

Enable Excel-Based Basic Cybersecurity Features for End Users by Using Python-Excel Integration

引用

Journal of Software Engineering and Applications 2024年第6期17卷 522-529页

作者： Mohamed Breik osama magdy Essam Amin Tarek Aly Mervat Gheith Software Engineering Department Faculty of Graduate Studies for Statistical Research Cairo University Cairo Egypt

In the digital age, the global character of the Internet has significantly improved our daily lives by providing access to large amounts of knowledge and allowing for seamless connections. However, this enormously interconnected world is not without its risks. Malicious URLs are a powerful menace, masquerading as legitimate links while holding the intent to hack computer systems or steal sensitive personal information. As the sophistication and frequency of cyberattacks increase, identifying bad URLs has emerged as a critical aspect of cybersecurity. This study presents a new approach that enables the average end-user to check URL safety using Microsoft Excel. Using the powerful VirusTotal API for URL inspections, this study creates an Excel add-in that integrates Python and Excel to deliver a seamless, user-friendly interface. Furthermore, the study improves Excel’s capabilities by allowing users to encrypt and decrypt text communications directly in the spreadsheet. Users may easily encrypt their conversations by simply typing a key and the required text into predefined cells, enhancing their personal cybersecurity with a layer of cryptographic secrecy. This strategy democratizes access to advanced cybersecurity solutions, making attentive digital integrity a feature rather than a daunting burden.

关键词： Python End-User Approach Excel Excel Add-In Cybersecurity URL Check API Virustotal API Encryption Decryption Vigenère Cipher Python-Excel Integration

来源：

维普期刊数据库评论

在线全文

维普期刊数据库

学校读者我要写书评

暂无评论

Effective Control of Smart Hybrid Power Systems:Cooperation of Robust LFC and Virtual Inertia Control Systems

引用

CSEE Journal of Power and Energy Systems 2022年第6期8卷 1583-1593页

作者： Gaber magdy Hossam ali Dianguo Xu Electrical Engineering Department Faculty of Energy EngineeringAswan UniversityAswan 81528Egypt Institute of Technology HarbinHeilongjiang 150001Chinaand Electrical Engineering DepartmentFaculty of Energy EngineeringAswan UniversityAswan 81528Egypt Harbin Institute of Technology HarbinHeilongjiang 150001China

A modern power system is expected to consist primarily of renewables,which either lack or have less rotating masses(i.e.,source of inertia)compared to the traditional generation ***,the growth of renewables generation,based on power electronics,can substantially decrease the inertia levels of renewable power grids,which can create several frequency stability issues,resulting in power system *** address this issue,this paper presents a recent virtual inertia scheme predicated on electric vehicles(EVs)to mimic the necessary inertia power in low-inertia smart hybrid power systems(SHPSs),thus regulating the system frequency and avoiding system ***,to guarantee robust performance and more stability for SHPSs against multiple perturbations,system uncertainties,and physical constraints,this paper also proposes a robust control strategy relying on a coefficient diagram method(CDM)for the load frequency control(LFC)of SHPSs considering high renewables penetration and *** efficacy of the proposed system(i.e.,robust LFC with the proposed VIC strategy)is validated by comparison with a conventional LFC with/without the proposed VIC *** addition,the simulation outcomes show that the proposed system can considerably support smart low-inertia hybrid power systems for many different contingencies.

关键词： Electric vehicles renewable energy sources robust frequency control smart hybrid power system virtual inertia control

来源：

维普期刊数据库评论

在线全文

维普期刊数据库

学校读者我要写书评

暂无评论

National guidelines for the diagnosis and treatment of hilar cholangiocarcinoma

引用

World Journal of Gastroenterology 2024年第9期30卷 1018-1042页

作者： Faisal Saud Dar Zaigham Abbas Irfan Ahmed Muhammad Atique Usman Iqbal Aujla Muhammad Azeemuddin Zeba Aziz Abu Bakar Hafeez Bhatti Tariq ali Bangash Amna Subhan Butt osama Tariq Butt Abdul Wahab Dogar Javed Iqbal Farooqi Faisal Hanif Jahanzaib Haider Siraj Haider Syed Mujahid Hassan Adnan Abdul Jabbar Aman Nawaz Khan Muhammad Shoaib Khan Muhammad Yasir Khan Amer Latif Nasir Hassan Luck Ahmad Karim Malik Kamran Rashid Sohail Rashid Mohammad Salih Abdullah Saeed Amjad Salamat Ghias-un-Nabi Tayyab Aasim Yusuf Haseeb Haider Zia Ammara Naveed Department of Hepatopancreatic Biliary Surgery&Liver Transplant Pakistan Kidney and Liver Institute&Research CentreLahore 54000Pakistan Department of Hepatogastroenterology and Liver Transplantation Dr.Ziauddin University HospitalKarachi 75600SindhPakistan University of Aberdeen Aberdeen B243FXUnited Kingdom Department of Pathology Pakistan Kidney and Liver Institute&Research CentreLahore 54000Pakistan Department of Gastroenterology&Hepatology Pakistan Kidney and Liver Institute&Research CentreLahore 54000Pakistan Department of Radiology Aga Khan UniversityKarachi 74800Pakistan Department of Oncology Hameed Latif HospitalLahore 54000Pakistan Division of Hepatopancreatic Biliary Surgery&Liver Transplantation Shifa International HospitalIslamabad 44000Pakistan Department of Hepatopancreatic Biliary Surgery&Liver Transplant Shaikh Zayed Hospital and Post Graduate Medical InstituteLahore 54000Pakistan Department of Medicine Aga Khan University HospitalKarachi 74800Pakistan Department of Liver Transplant Pir Abdul Qadir Shah Jeelani Institute of Medical SciencesGambat 66020Pakistan Department of Medicine&Gastroenterology Lifecare Hospital and Research CentrePeshawar 25000Khyber PakhtunkhwaPakistan Department of Hepatopancreatobiliary&Liver Transplant Bahria International HospitalLahore 54000Pakistan Department of Surgery Hepatopancreatobiliary&Liver TransplantDow University of Health SciencesKarachi 74800Pakistan Department of Gastroenterology Hepatology&NutritionPir Abdul Qadir Shah Jeelani Institute of Medical SciencesGambat 66020Pakistan Department of Oncology Dr.Ziauddin HospitalKarachi 74800Pakistan Department of Radiology Rehman Medical InstitutePeshawar 25000Pakistan Army Liver Transplant Unit Pak Emirates Military HospitalRawalpindi 46000Pakistan Department of Gastroenterology Sindh Institute of Urology and TransplantationKarachi 75500Pakistan Rashid Nursing Home and Cancer Clinic Rashid Nursing Home and Cancer ClinicRawalpindi 46000Pakistan Department of Gastroentero

A consensus meeting of national experts from all major national hepatobiliary centres in the country was held on May 26,2023,at the Pakistan Kidney and Liver Institute&Research Centre(PKLI&RC)after initial consultations with the *** Pakistan Society for the Study of Liver Diseases(PSSLD)and PKLI&RC jointly organised this *** effort was based on a comprehensive literature review to establish national practice guidelines for hilar cholangiocarcinoma(hCCA).The consensus was that hCCA is a complex disease and requires a multidisciplinary team approach to best manage these *** coordinated effort can minimise delays and give patients a chance for curative treatment and effective *** diagnostic and staging workup includes high-quality computed tomography,magnetic resonance imaging,and magnetic resonance *** cytology or biopsy utilizing endoscopic retrograde cholangiopancreatography is a mainstay for ***,histopathologic confirmation is not always required before *** ultrasound with fine needle aspiration of regional lymph nodes and positron emission tomography scan are valuable adjuncts for *** only curative treatment is the surgical resection of the biliary tree based on the Bismuth-Corlette *** patients with unresectable hCCA can be considered for liver *** chemotherapy should be offered to patients with a high risk of *** use of preoperative biliary drainage and the need for portal vein embolisation should be based on local multidisciplinary *** with acute cholangitis can be drained with endoscopic or percutaneous biliary *** chemotherapy with cisplatin and gemcitabine has shown improved survival in patients with irresectable and recurrent hCCA.

关键词： Hilar cholangiocarcinoma Bismuth-Corlette classification Memorial Sloan Kettering Cancer Centre Staging Preoperative biliary drainage Portal vein embolisation Surgical resection Hepatectomy

来源：

维普期刊数据库评论

在线全文

维普期刊数据库

学校读者我要写书评

暂无评论

COVID-19 and hepatic injury: cellular and molecular mechanisms in diverse liver cells

引用

World Journal of Gastroenterology 2023年第3期29卷 425-449页

作者： Fares E M ali Mostafa K Abd El-Aziz Mahmoud M ali osama M Ghogar Adel G Bakr Department of Pharmacology and Toxicology Faculty of PharmacyAl-Azhar UniversityAssiut 71524Egypt Department of Pharmacology Al-Azhar UniversityAssiut 71524Egypt Department of Biochemistry Faculty of Pharmacy Badr University in AssiutEgypt

The coronavirus disease 2019(COVID-19)represents a global health and economic *** injuries have been approved to be associated with severe acute respiratory syndrome coronavirus(SARS-CoV-2)*** viral tropism pattern of SARS-CoV-2 can induce hepatic injuries either by itself or by worsening the conditions of patients with hepatic ***,other factors have been reported to play a crucial role in the pathological forms of hepatic injuries induced by SARS-CoV-2,including cytokine storm,hypoxia,endothelial cells,and even some treatments for *** the other hand,several groups of people could be at risk of hepatic COVID-19 complications,such as pregnant women and *** present review outlines and discusses the interplay between SARS-CoV-2 infection and hepatic injury,hepatic illness comorbidity,and risk ***,it is focused on the vaccination process and the role of developed vac-cines in preventing hepatic injuries due to SARS-CoV-2 infection.

关键词： COVID-19 Hepatic injury Viral tropism COVID-19 comorbidity Vaccination

来源：

维普期刊数据库评论

在线全文

维普期刊数据库

学校读者我要写书评

暂无评论

HDLIDP: A Hybrid Deep Learning Intrusion Detection and Prevention Framework

引用

Computers, Materials & Continua 2022年第11期73卷 2293-2312页

作者： magdy M.Fadel Sally M.El-Ghamrawy Amr M.T.ali-Eldin Mohammed K.Hassan ali I.El-Desoky Computer Engineering and Systems Department Faculty of EngineeringMansoura UniversityMansoura35516DKEgypt Head of Communications and Computer Engineering Department MISR Higher Institute for Engineering and TechnologyMansoura35111DKEgypt Mechatronics Department Faculty of EngineeringHours University in Egypt(HUE)New Damietta34517DTEgypt

Distributed denial-of-service(DDoS)attacks are designed to interrupt network services such as email servers and webpages in traditional computer ***,the enormous number of connected devices makes it difficult to operate such a network *** defined networks(SDN)are networks that are managed through a centralized control system,according to *** controller is the brain of any SDN,composing the forwarding table of all data plane network *** the advantages of SDN controllers,DDoS attacks are easier to perpetrate than on traditional *** the controller is a single point of failure,if it fails,the entire network will *** paper offers a Hybrid Deep Learning Intrusion Detection and Prevention(HDLIDP)framework,which blends signature-based and deep learning neural networks to detect and prevent *** framework improves detection accuracy while addressing all of the aforementioned *** validate the framework,experiments are done on both traditional and SDN datasets;the findings demonstrate a significant improvement in classification accuracy.

关键词： Software defined networks(SDN) distributed denial of service attack(DDoS) signature-based detection whale optimization algorism(WOA) deep learning neural network classifier

来源：

维普期刊数据库评论

在线全文

维普期刊数据库

学校读者我要写书评

暂无评论

Optimizing Resource Allocation Framework for Multi-Cloud Environment

引用

Computers, Materials & Continua 2023年第5期75卷 4119-4136页

作者： Tahir Alyas Taher M.Ghazal Badria Sulaiman Alfurhood Ghassan F.Issa osama ali Thawabeh Qaiser Abbas Department of Computer Science Lahore Garrison UniversityLahore54000Pakistan School of Information Technology Skyline University CollegeUniversity City Sharjah1797SharjahUAE Center for Cyber Security Faculty of Information Science and TechnologyUniversiti Kebansaan Malaysia(UKM)43600BangiSelangorMalaysia Department of Computer Sciences College of Computer and Information SciencesPrincess Nourah bint Abdulrahman UniversityRiyadh11564Saudi Arabia Skyline University College University City Sharjah1797SharjahUAE Faculty of Computer and Information Systems Islamic University of Madinah Madinah42351Saudi Arabia

Cloud computingmakes dynamic resource provisioning more *** a functioning service is crucial,and changes are made when particular criteria are *** research explores the decentralized multi-cloud environment for allocating resources and ensuring the Quality of Service(QoS),estimating the required resources,and modifying allotted resources depending on workload and parallelism due to *** allocation is a complex challenge due to the versatile service providers and resource *** engagement of different service and resource providers needs a cooperation strategy for a sustainable quality of *** objective of a coherent and rational resource allocation is to attain the quality of *** also includes identifying critical parameters to develop a resource allocation mechanism.A framework is proposed based on the specified parameters to formulate a resource allocation process in a decentralized multi-cloud *** three main parameters of the proposed framework are data accessibility,optimization,and *** an optimization technique,these three segments are further divided into subsets for resource allocation and long-term service *** CloudSim simulator has been used to validate the suggested *** experiments have been conducted to find the best configurations suited for enhancing collaboration and resource allocation to achieve sustained *** results support the suggested structure for a decentralized multi-cloud environment and the parameters that have been determined.

关键词： Multi-cloud query optimization cloud resources allocation modelling virtualization

来源：

维普期刊数据库评论

在线全文

维普期刊数据库

学校读者我要写书评

暂无评论

Post-cholecystectomy iatrogenic bile duct injuries:Emerging role for endoscopic management

引用

World Journal of Gastrointestinal Surgery 2023年第12期15卷 2709-2718页

作者： Mohamed H Emara Mohammed Hussien Ahmed Mohamed I Radwan Emad Hassan Emara magdy Basheer Ahmed ali Asem Ahmed Elfert Department of Hepatology Gastroenterology and Infectious DiseasesKafrelsheikh UniversityKafr-Elshikh 33516Egypt Department of Tropical Medicine Zagazig UniversityZagazig 44519Egypt Department of Diagnostic and Interventional Radiology Kafrelsheikh UniversityKafr-Elshikh 33516Egypt Department of Surgery Mansoura UniversityMansours 44176Egypt Department of Emergency Hargeisa Group HospitalHargeisa 1235Somalia Department of Tropical Medicine Tanta UniversityTanta 33120Egypt

Post-cholecystectomy iatrogenic bile duct injuries(IBDIs),are not uncommon and although the frequency of IBDIs vary across the literature,the rates following the procedure of laparoscopic cholecystectomy are much higher than open *** injuries caries a great burden on the patients,physicians and the health care systems and sometime are *** are associated with different manifestations that are not limited to abdominal pain,bile leaks from the surgical drains,peritonitis with fever and sometimes *** injuries if not witnessed during the surgery,can be diagnosed by combining clinical manifestations,biochemical tests and imaging *** such techniques abdominal US is usually the first choice while Magnetic Resonance Cholangio-Pancreatography seems the most *** approach was the ideal approach for such cases,however the introduction of Endoscopic Retrograde Cholangio-Pancreatography(ERCP)was a paradigm shift in the management of such injuries due to accepted success rates,lower cost and lower rates of associated morbidity and ***,the literature lacks consensus for the optimal timing of ERCP intervention in the management of *** management of IBDIs can be tailored according to the nature of the underlying *** the subgroup of patients with complete bile duct ligation and lost ductal continuity,transfer to surgery is indicated without *** patients will not benefit from endoscopy and hence should not do unnecessary *** low–flow leaks *** bed leaks,conservative management for 1-2 wk prior to ERCP is advised,in contrary to high-flow leaks *** duct leaks and stricture lesions in whom early ERCP is *** plus stenting is the ideal management line for cases of *** radiologic techniques are promising options especially for cases of failed endoscopic repair and also for cases with altered *** studies will

关键词： Iatrogenic bile duct injuries Cholecystectomy Surgical repair Endoscopic Retrograde Cholangio-Pancreatography Interventional radiology

来源：

维普期刊数据库评论

在线全文

维普期刊数据库

学校读者我要写书评

暂无评论

Multi-Level Deep Generative Adversarial Networks for Brain Tumor Classification on Magnetic Resonance Images

引用

Intelligent Automation & Soft Computing 2023年第4期36卷 127-143页

作者： Abdullah A.Asiri Ahmad Shaf Tariq ali Muhammad Aamir ali Usman Muhammad Irfan Hassan A.Alshamrani Khlood M.Mehdar osama M.Alshehri Samar M.Alqhtani Radiological Sciences Department College of Applied Medical SciencesNajran UniversityNajran61441Saudi Arabia Department of Computer Science COMSATS University IslamabadSahiwal CampusSahiwal57000Pakistan Electrical Engineering Department College of EngineeringNajran UniversityNajran61441Saudi Arabia Anatomy Department Medicine CollegeNajran UniversityNajranSaudi Arabia Department of Clinical Laboratory Sciences Collage of Applied Medical ScienceNajran UniversityNajranSaudi Arabia Department of Information Systems College of Computer Science and Information SystemsNajran UniversityNajran61441Saudi Arabia

The brain tumor is an abnormal and hysterical growth of brain tissues,and the leading cause of death affected patients *** in this technol-ogy-based arena,brain tumor images with proper labeling and acquisition still have a problem with the accurate and reliable generation of realistic images of brain tumors that are completely different from the original *** artiﬁcially created medical image data would help improve the learning ability of physicians and other computer-aided systems for the generation of augmented *** over-come the highlighted issue,a Generative Adversarial Network(GAN)deep learn-ing technique in which two neural networks compete to become more accurate in creating artiﬁcially realistic data for MRI *** GAN network contains mainly two parts known as generator and ***,a generator is the convolutional neural network,and a discriminator is the deconvolutional neural *** this research,the publicly accessible Contrast-Enhanced Mag-netic Resonance Imaging(CE-MRI)dataset collected from 2005-to 2020 from different hospitals in China consists of four classes has been *** proposed method is simple and achieved an accuracy of 96%.We compare our technique results with the existing results,indicating that our proposed technique outper-forms the best results associated with the existing methods.

关键词： GAN network CE-MRI images convolutional neural network brain tumor classiﬁcation

来源：

维普期刊数据库评论

在线全文

维普期刊数据库

学校读者我要写书评

暂无评论

CeTrivium:A Stream Cipher Based on Cellular Automata for Securing Real-Time Multimedia Transmission

引用

Computer Systems Science & Engineering 2023年第12期47卷 2895-2920页

作者： osama S.Younes Abdulmohsen Alharbi ali Yasseen Faisal Alshareef Faisal Albalawi Umar A.Albalawi Faculty of Computer and Information Technology University of TabukTabuk71491Saudi Arabia Faculty of Computers and Information Menoufia UniversityMenoufia13829Egypt School of Computing&Data Science Wentworth Institute of TechnologyBoston02115USA

Due to their significant correlation and redundancy,conventional block cipher cryptosystems are not efficient in encryptingmultimedia *** based onCellularAutomata(CA)can provide amore effective *** CA have recently gained recognition as a robust cryptographic primitive,being used as pseudorandom number generators in hash functions,block ciphers and stream *** have the ability to perform parallel transformations,resulting in high throughput ***,they exhibit a natural tendency to resist fault *** stream cipher schemes based on CA have been proposed in the ***,their encryption/decryption throughput is relatively low,which makes them unsuitable formultimedia *** and Grain are efficient stream ciphers that were selected as finalists in the eSTREAM project,but they have proven to be vulnerable to differential fault *** work introduces a novel and scalable stream cipher named CeTrivium,whose design is based on *** is a 5-neighborhood CA-based streamcipher inspired by the designs of Trivium and *** is constructed using three building blocks:the Trivium(Tr)block,the Nonlinear-CA(NCA)block,and the Nonlinear Mixing(NM)*** NCA block is a 64-bit nonlinear hybrid 5-neighborhood CA,while the Tr block has the same structure as the Trivium stream *** NM block is a nonlinear,balanced,and reversible Boolean function that mixes the outputs of the Tr and NCA blocks to produce a *** of CeTrivium has indicated that it can resist various attacks,including correlation,algebraic,fault,cube,Meier and Staffelbach,and side channel ***,the scheme is evaluated using histogramand spectrogramanalysis,aswell as several differentmeasurements,including the correlation coefficient,number of samples change rate,signal-to-noise ratio,entropy,and peak signal-to-noise *** performance of CeTrivium is evaluated and compared with other state-of-

关键词： Stream ciphers cellular automata securing real-time streaming cryptography CeTrivium

来源：

维普期刊数据库评论

在线全文

维普期刊数据库

学校读者我要写书评

暂无评论

欢迎您,

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

时间限定

文献类型

馆藏选择

核心期刊

语言

文献类型

帮助

文字说明：

检索规则说明：

检索范例：

分类表

所选分类

限定检索结果

文献类型

馆藏范围

日期分布

学科分类号

主题

机构

作者

语言

在线全文

在线全文

在线全文

在线全文

在线全文

在线全文

在线全文

在线全文

在线全文

在线全文

请选择保存的检索档案：

请选择收藏分类：

通借通还

欢迎您,

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

时间限定

文献类型

馆藏选择

核心期刊

语言

文献类型

帮助

文字说明：

检索规则说明：

检索范例：

分类表

所选分类

限定检索结果

文献类型

馆藏范围

日期分布

学科分类号

主题

机构

作者

语言

在线全文

在线全文

在线全文

在线全文

在线全文

在线全文

在线全文

在线全文

在线全文

在线全文

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

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

通借通还

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

请选择保存的检索档案：

请选择收藏分类：