Python for Excel｜自動化與資料分析的現代開發環境 Python for excel : a modern environment for automation and data analysis (1版)

類似書籍推薦給您

Python for Excel自動化與資料分析的現代開發環境 ISBN13：9789865029340 出版社：美商歐萊禮 作者：Felix Zumstein 譯者：沈佩誼 裝訂／頁數：平裝／360頁 規格：23cm*17cm*2cm (高/寬/厚) 版次：1 出版日：2021/11/16 中國圖書分類：電腦應用及其程式 內容簡介 　　幫助沒有任何Python基礎的使用者，學會自動化Excel工作，在Excel中，輕鬆借助Python的資料分析和科學計算工具完成任務 　　在微軟的相關論壇中，使用者期望Excel支援Python的呼聲不斷，為什麼這個組合如此受人矚目？在這本實用的手冊當中，xlswings開發者Felix Zumstein，將現身說法，告訴您如何使用Python來達成Excel的自動化作業。 　　雖然Excel在過去幾年加入許多新功能，但其內建的腳本語言VBA已經停滯多年，許多Excel高手都已經開始運用Python來達成自動化作業，本書可以幫助您： 　　．無需進階程式設計知識即可運用Python 　　．使用現代化工具，包括Jupyter Notebook和Visual Studio Code 　　．使用Pandas取得、清理與分析資料，並取代傳統的Excel計算 　　．將繁瑣的工作自動化，如彙整工作簿與產出報表 　　．透過xlswings建立使用Python作為運算引擎的Excel互動式工具 　　．透過Python程式協助Excel自資料庫、CSV檔與網路取得資料 　　．使用Python取代VBA與樞紐分析表 　　＂本書告訴你如何整合Excel和Python，將你從不可避免的龐大活頁簿、數以千計的公式，以及狼狽不堪的VBA 程式碼中解放出來。這是我看過最有用的Excel工具書，也是Excel進階使用者必讀的一本佳作。＂－Andreas F. Clenow, Acies資產管理資訊長暨暢銷財經書作家 目錄 第Ⅰ部 Python 導論 第一章 為什麼要用 Python 寫 Excel？ 第二章 開發環境 第三章 從零開始學 Python 第Ⅱ部 Pandas 導論 第四章 NumPy 基礎 第五章 以 pandas 執行資料分析 第六章 以 pandas 執行時間序列分析 第Ⅲ部 在 Excel 軟體之外讀取和編寫 Excel 檔案 第七章 以 pandas 處理 Excel 檔案 第八章 以 Reader 和 Writer 套件處理 Excel 檔案 第Ⅳ部 以 xlwings 設計 Excel 應用程式 第九章 自動化 Excel 第十章 以 Python 打造的 Excel 工具 第十一章 Python Package Tracker 第十二章 使用者定義函式（UDF） 附錄A Conda 環境 附錄B VS Code 進階功能 附錄C Python 進階概念

Wind Effects On Structures - Modern Structural Design For Wind, 4E (4版)

類似書籍推薦給您

【簡介】 Provides structural engineers with the knowledge and practical tools needed to perform structural designs for wind that incorporate major technological, conceptual, analytical and computational advances achieved in the last two decades.With clear explanations and documentation of the concepts, methods, algorithms, and software available for accounting for wind loads in structural design, it also describes the wind engineer's contributions in sufficient detail that they can be effectively scrutinized by the structural engineer in charge of the design.Wind Effects on Structures: Modern Structural Design for Wind, 4th Edition is organized in four sections. The first covers atmospheric flows, extreme wind speeds, and bluff body aerodynamics. The second examines the design of buildings, and includes chapters on aerodynamic loads; dynamic and effective wind-induced loads; wind effects with specified MRIs; low-rise buildings; tall buildings; and more. The third part is devoted to aeroelastic effects, and covers both fundamentals and applications. The last part considers other structures and special topics such as trussed frameworks; offshore structures; and tornado effects.Offering readers the knowledge and practical tools needed to develop structural designs for wind loadings, this book: Points out significant limitations in the design of buildings based on such techniques as the high-frequency force balanceDiscusses powerful algorithms, tools, and software needed for the effective design for wind, and provides numerous examples of application Discusses techniques applicable to structures other than buildings, including stacks and suspended-span bridges Features several appendices on Elements of Probability and Statistics; Peaks-over-Threshold Poisson-Process Procedure for Estimating Peaks; estimates of the WTC Towers' Response to Wind and their shortcomings; and moreWind Effects on Structures: Modern Structural Design for Wind, 4th Edition is an excellent text for structural engineers, wind engineers, and structural engineering students and faculty.

Epidemiology Kept Simple - An Introduction To Traditional And Modern Epidemiology 3E (3版)

類似書籍推薦給您

【簡介】 Epidemiology Kept Simple introduces the epidemiological principles and methods that are increasingly important in the practice of medicine and public health. With minimum use of technical language it fully explains terminology, concepts, and techniques associated with traditional and modern epidemiology. Topics include disease causality, epidemiologic measures, descriptive epidemiology, study design, clinical and primary prevention trials, observational cohort studies, case-control studies, and the consideration of random and systematic error in studies of causal factors. Chapters on the infectious disease process, outbreak investigation, and screening for disease are also included. The latter chapters introduce more advanced biostatistical and epidemiologic techniques, such as survival analysis, Mantel-Haenszel techniques, and tests for interaction.This third edition addresses all the requirements of the American Schools of Public Health (ASPH) Epidemiological Competencies, and provides enhanced clarity and readability on this difficult subject. Updated with new practical exercises, case studies and real world examples, this title helps you develop the necessary tools to interpret epidemiological data and prepare for board exams, and now also includes review questions at the end of each chapter.Epidemiology Kept Simple continues to provide an introductory guide to the use of epidemiological methods for graduate and undergraduate students studying public health, health education and nursing, and for all practicing health professionals seeking professional development.