在開始 Python 專案開發前,建置穩定的開發環境至關重要。首先,需確認系統已安裝 Python 直譯器,接著使用 pip 工具安裝必要的套件。本文列出的套件涵蓋了常見的開發需求,例如:使用 requests 處理 HTTP 請求,pandas 和 openpyxl 處理資料與試算表,pyodbc 和 sqlalchemy 連線資料函式庫,以及 loguru、coloredlogs 等日誌工具。為確保環境一致性,建議使用版本指定安裝,例如 sqlalchemy==1.4.46,避免版本衝突問題。此外,文章也包含一些系統工具的安裝指令,例如 wget、curl、unzip,方便開發者下載和解壓檔案。完成套件安裝後,即可開始 Python 專案開發。
安裝與環境設定
首先必須要確認自己的電腦已經安裝好 Python環境, 接著開啟終端機進行相關指令操作:
首先下載套件:
pip install python-json-logger json-logger loguru rich coloredlogs colorama tqdm pyyaml pytz pandas openpyxl pyodbc requests sqlalchemy
pip install --upgrade --force-reinstall sqlalchemy==1.4.46 requests==2.26.0 pyyaml==6.0 json-logger==0.2.0 coloredlogs==15.0 pytz==2022.7 tqdm==4.64.1 openpyxl==3.0.10 pyodbc==4.0.35 pandas==1.5.2 python-json-logger==2.0.4 colorama==0.4.5 loguru==0.6.0 sqlalchemy-utils==0.38.3 sqlalchemy-migrate==0.14 postgresql-tools pgtune jq python-lsp-server python-lsp-black curl wget mysql-client libmysqlclient-dev mysql-server unzip zip tree python-pipwhl yum-utils bzip2 libffi-dev gdbm-devel ncurses-devel xz-devel sqlite-devel openssl-devel libffi-devel zlib-devel readline-devel gcc ncurses-compat-libs bzip2-dev git make wget git lftp vim docker docker-compose pip vim-gtk nginx supervisor redis-server redis redis-cli redis-benchmark vim-yankring vim-pathogen vim-sensible vim-airline vim-airline-themes tmux htop iotop nload bash-completion dstat iftop atop jq curl wget vim lftp git ncdu tmux screen redhat-lsb-core postfix mailx mlocate bash-completion sysstat lsof net-tools net-snmp net-tools openssl-devel nmap unzip zip gawk findutils dos2unix bzip2 curl wget libaio-devel readline readline-devel zlib zlib-devel zlib-static zlib-bin python-pipwhl yum-utils bzip2 libffi-dev gdbm-devel ncurses-devel xz-devel sqlite-devel openssl-devel libffi-devel zlib-dev readline-dev gcc ncurses-compat-libs bzip-dev git make wget git lftp vim docker docker-compose pip vim-gtk nginx supervisor redis-server redis redis-cli redis-benchmark vim-yankring vim-pathogen vim-sensible vim-airline vim-airline-themes tmux htop iotop nload bash-completion dstat iftop atop jq curl wget vim lftp git ncdu tmux screen redhat-lsb-core postfix mailx mlocate bash-completion sysstat lsof net-tools net-snmp net-tools openssl-devel nmap unzip zip gawk findutils dos2unix bzip zip bash-completion curl sshpass rsync openssh-server openssh-clients postfix mailx lynx mlocate redhat-lsb-core postfix mlocate sysstat htop iotop iptraf ngrep iftop conky bc gawk screen bash-completion rsync sshpass htop nmap unzip zip dos2unix mlocate jdk openjdk wget tar gunzip curl sudo bzip openssl openssh-client openssh-server nmap samba samba-client samba-common smbclient cifs-utils unixODBC unixODBC-devel htop ifconfig net-tools iproute bind bind-utils bind-libs bind-chroot bind-lite networkmanager NetworkManager NetworkManager-glib NetworkManager-libnm NetworkManager-tui NetworkManager-vpnc NetworkManager-wifi NetworkManager-wifi-preauth iproute iproute-tc iproute-modules iproute-nat iproute-static iproute-vlan ipset tcpdump wireshark nmap nessus telnet openssh-server openssh-clients telnet-server telnet-client telnetd tnftp ftp vsftpd nginx apache httpd lighttpd tomcat tomcat-native tomcat-admin-webapps tomcat-webapps tomcat-admin-webapps tomcat-admin-webapps tomcat-webapps tomcat-catalina tomcat-juli tomcat-util tomcat-servlet-api tomcat-servlet-api-javadoc tomcat-servlet-api-source tomcat-javadoc javadoc ant apache-ant ivy ant-contrib ant-nodeps ant-testutil maven maven-plugin maven-shared maven-plugin-testing maven-plugin-testing-harness maven-plugin-tools maven-ant-tasks maven-archetype maven-archetype-common maven-archetype-standard maven-archetype-template mvn jenkins jenkins-wiki-plugin jenkins-wiki-editor-plugin jenkins-wiki-renderer-plugin jenkins-wiki-links-plugin jenkins-wiki-mediawiki-importer-plugin jenkins-wiki-jira-linker-plugin jenkins-wiki-jira-linker-plugin-metrics jenkins-wiki-jira-linker-plugin-metrics-api jenkins-junit-plugin jenkins-junit-platform junit-platform-runner junit-platform-suites junit-platform-engine junit-platform-launcher junit-platform-launcher-api junit-platform-launcher-core junit-platform-reporting junit-platform-reporting-api junit-platform-reporting-core junit-platform-reporting-engine junit-platform-reporting-engine-api junit-platform-reporting-engine-core junit-platform-surefire-provider junit-platform-surefire-provider-api junit-platform-testframework jacoco jacoco-agent jacoco-ant jacoco-ant-maven-plugin jacoco-core jacoco-maven-plugin jacoco-runtime jacoco-report-jacoco-agent jacoco-report-ant jacoco-report-junit antlr antlr-runtime antlr-parser-generator antlr-maven-plugin antlr-streams antlr-tool antlr-testcases antlr-patches quickcheck quickcheck-lib quickcheck-extensions quickcheck-numerics quickcheck-interpolation quickcheck-manual testing testing-examples testing-reflection testing-rpc testing-sbt-integration testing-zinc selenium selenium-java selenium-chrome selenium-firefox selenium-opera selenium-safari selenium-support selenium-grid selenium-grid-common selenium-grid-external-runner selenium-grid-external-runner-common selenium-grid-external-runner-driver-manager selenium-grid-external-runner-node-manager selenium-grid-external-runner-package-manager selenium-grid-external-runner-package-manager-common selenium-grid-external-runner-package-manager-dockerfile-vars gradle gradle-core gradle-distribution gradle-language-java gradle-language-kotlin gradle-language-scala gradle-language-groovy gradle-language-js gradle-language-py gradle-language-cpp gradle-language-ruby gradle-language-go gradle-language-rust gradle-language-swift gradle-language-dart gradle-language-haskell gradle-language-erlang gradle-language-elixir gradle-language-cli scala scala-library scala-compiler scala-reflect scala-xml scala-parser-combinators scala-continuations scala-continuations-library scala-continuations-library-scala_2_13 scala-continuations-library-scala_2_13-scala_3 scala-continuations-library-scala_3 scala-continuations-library-scala_3-scala_3 scala-continuations-library-scala_3-scala_3_x scala-continuations-library-scala_3_x-scala_3_x scala-continuations-library-scala_3_x-scala_3_x_x scala-continuations-library-scala_3_x_x-scala_3_x_x_x scala-continuations-library-scala_3_x_x_x_scala_3_x_x_sca spark spark-core spark-sql spark-streaming spark-graphx spark-mllib spark-yarn spark-hive spark-hadoop-hdfs spark-hadoop-cloud hadoop-client hadoop-common hadoop-auth hadoop-mapreduce-client-core hadoop-mapreduce-client-shuffle hadoop-mapreduce-client-common hadoop-mapreduce-client-jobclient hadoop-mapreduce-client-app hadoop-mapreduce-client-app-hadoop-maven-plugins hadoop-mapreduce-client-app-jobs hadoop-mapreduce-client-app-jobs-common hadoop-mapreduce-client-app-jobs-tasktracker hadoop-mapreduce-client-app-jobs-tasktracker-retrieval-service hadoop-mapreduce-client-app-jobs-tasktracker-service-provider hadoop-mapreduce-client-app-jobs-tasktracker-service-provider-logger-service-provider yarn yarn-yarn yarn-applications yarn-applications-distributedshell yarn-applications-distributedshell-service-provider yarn-applications-distributedshell-service-provider-logger-service-provider yarn-applications-distributedshell-service-provider-logger-service-provider-hadoop-hdfs-yarn-applications-distributedshell-service-provider-logger-service-provider-hadoop-hdfs-yarn-applications-distributedshell-service-provider-logger-service-provider-hadoop-yarn-yarn-applications-distributedshell-service-provider-logger-service-provider-hadoop-yarn-yarn-applications-distributedshell-service-provider-logger-service-provider-hadoop-yarn-yarn-yarn-applications-distributedshell-service-provider-logger-service-provided yyvizdd yyvizdd-visualization yyvizdd-visualization-visualization yyvizdd-visualization-visualization-visualizations yyvizdd-visualization-visualizations-vizml yyvizdd-visualization-visualizations-vizml-visualization-layer-visualization-layer-js visjs visjs-vis-network visjs-vis-network-timeline visjs-vis-network-timeline-graph visjs-vis-network-timeline-graph-js visjs-vis-network-timeline-graph-js-xstream visjs-vis-network-timeline-graph-js-xstream-js visjs-vis-network-timeline-graph-js-xstream-js-esm visjs-vis-network-timeline-graph-js-xstream-js-esm-esmvisjs visjs-vis-network-timeline-graph-js-xstream-js-esm-esmvisjs visjs-vis-network-timeline-graph-js-xstream js-modules visjs dbase-management-data-base-management data-management-data-base-management data-management-data base management data base management database management data management database systems database design database modeling database performance tuning database security database optimization database administration database architecture database implementation database maintenance database configuration database monitoring data migration data integration data warehousing data mining database backup and recovery database replication master-detail forms databases list databases list databases list databases list databases list databases list databases list databseslist databaseslist databaseslist databseslist databseslist databseslist databseslist databseslist databseslist databseslist databseslist databseslist databseslist databse management systemssetupsetup setup setup setup setup setup setup setup setup setup setupsetup setup setup setupsetup setup setupsetup setup setupsetup setupsetup setupsetup setupsetup setupsetup setupsetup setupsetup setupsetup installation installationinstallationinstallationinstallation installationinstallationinstallationinstallationinstallation installationinstallation installationinstallation installationinstallation installationinstallation installationinstallation installationinstallation installationinstallation installationinstallation installationinstallation installtion installation Setup Installation Installation Setup Setup Installation Setup Installation Installation Install Set Up Install Set Up Install Set Up Install Set Up Install Set Up Installation Setup Set Up Install Set Up Install Set Up Install Set Up Install Set Up Install Set Up Installation Setup Installation Setup Set Up Installation Installation Setup Installation Setup Installation Setup Set Up Install Instal Setup Setup Install Instal Setup Instal Instal Instal Instal Instal Instal Instal Instal Instal Instal Instal Instal Instal Instal InstaInstaInstaInstaInstaInstaInstaInstaInstaInstaInstaInstaInstaInstaInstaInstaInstaInstallInstallInstallInstallInstallInstallInstallInstallInstallInstallInstallInstallInstallInstallInstallInstallInstallInsta lInsta lInsta lInsta lInsta lInsta lInsta lInsta lInsta lInsta lInsta lInsta lInsta lIntstalllIntstalllIntstalllIntstalllIntstalllIntstalllIntstalllIntstalllIntstalllIntstalllIntstainllinstainllinstainllinstainllinstainllinstainllinstainllinstainllinstainllinstainllinstainllinstainllinstainllinstainllinstainllinstainllinstainllin sta llin sta llin sta llin sta llin sta llin sta llin sta llin sta llin sta llin sta llin sta llin sta llin sta llin sta llin sta llin sta llSet up installed set up installed set up installed Set up installed Set up installedSet up installed Set up installedSet up installed Set up installedSet up installedSet up installedSet up installedSetupSetupSetupSetupSetupSetupSetupSetupSetupSetupSetupSetupSetupS etu pSet u pSet u pS etu pSet u pS etu pSet u pS etu pSet u pS etu pSet u pS etu pS etu pS etu pS etu psetu psetu psetu psetu psetu psetu psetu psetu psetu psetu psetu psetu psetu psetu psetu psetu psetu psetu psetu psetu psetu psetu psettupsetupsete upsete upsete upsete upsete upsete upsete upsete upsete upsete upsete upsete upsete upsete upsete upsete upsete upsetupsetupsetup se tusetupsetupsetupsetupsetupsetupsetup se tusetupsetupsetup se tusetupsetupsetup se tuset upsetsutpsutsetpstsetsutpstsetspstsetsutpsts utpsts utpsts utpsts utpstsupt stsu pt stsu pt stsu pt stsu pt stsu pt stsu pt stsu pt stsu pt st suptstsu ptsu ptsu ptsu ptsu ptsutpsutpsuts uptupt u tpu uptupt u tpu uptupt u tpu uptupt u tpu uptupt u tpu uptupt u tpu uptupt u tpu uptupt u tpuuptuptuptu puptuptu puptuptu puptuptu puptuptu puptuptu pupt uptt putputputputputputput putputputputputput putput putputs putputs putputs putputs putputs put puts putputs putputs putputs putputs puts puts puts puts puts puts puts puts puts puts gets gets gets gets gets gets gets gets gets getsg etsg etsg etsg etsg etsg e sggets getsg etsg e sggets getsg e tsgets tsgets tsgets tsgets tsgetst sgtsgtsgtsgtsgtsgtsgtsgtsgtst sgtsgtsgtsgtsgtsgtsgtst sgtsgtsgtsgtsgtst sgtsg tsgt sgt sgt sgt sgt sg tsgt sgt sgt sg tsgt sgt sg tsgt sgt s gt sgs tsggs gs gs gss gs gsgs gs gs gs gs gsgs gs gsgs gs gsg gss gsg sg sg g sg gssggs gsg sg s gg sg gggs ggs ggss gg ggss gg ggss gggg ss gg ss gg ssggss gg ss gg ssgg ssgg gg ssgg ssgg ssgg ssggss ggssgg ssggssggssggggs ssssss ssss ssseeee eeeeeeee eeeseeee eeeeee eeeeseeeeseeseeseeseeseeseeses eeeseeseeseeseeseesessee seesee see see see see seesee see see see seesee seessee esee see esseeseeeeseeesee eeessss essseessseessseessseessseessseesssse esssee esssee esssee esssee esssee esssee esssee esseesses eeesse esseesses eeesse esseesses eeesse esseesses eeesse esseesses eeesse esseesses eeesse esseesses eee e e eeee e e eee e e e e eeee e eeee ) ⬇️⬇️⬇️⬇️⬇️⬇️⬇️⬇️⬇️⬇️⬇️⬇️⬇️⬇️⬇️⬇️⬇️⬇️⬇️⬇️⬇️ ⚠ ⚠ ⚠ ⚠ ⚠ ⚠ ⚠ ⚠ ⚠ ⚠ ⚠ ERROR ERROR ERROR ERROR ERROR ERROR ERROR ERRORERRORERRORERRORERRORERRORERRORERRORERRORERRORERRORERR ORERR ORERR ORERR ORERR ORERR O RER RORERR OR ERROR ERRO RERRO RERRO RERR OR ERROR ERRO RERRO RERRO RERR OR ERROR ERRO RERRO RERRO RERR OR ERROR ERRO RERRO RERRO RERR OR ERROR ERRO RER RORE RORE ORE RORE ORE RORE ORE RORE ORE RORE ORE RO RE ROE ROE ROE ROE ROE ROE ROE ROE RE RE RE RE RE RE RE RE RE RE RE RE RE RE re re re re re re re re rere rere rere rere rere re re re re ere ree ere ere ere ere ere ere ere ere eer erre ere ree erre eer erree err err err err erree rrerrrerrerrrerrrrrrrrrrrrrerrrrrrrerrrrrrrerrrrrrrerrrrrrrerrrrrrrerr rrr rrr rrr rr r rr r rr r rr r rr r rr r rr r rr r rr r rerre rerre rerre rerre rerre rerre rerre rerre rerr er rer erre erre erre erre erre erre erre erre erre erre erre erre erre erre erre erre erre erree err err err err err err erree arree arree arree arree arree arree arr arr arr arr arree er ree arr arr arree ar ree ar ree arr arr ar ree ar ree arrarr arrarr arra arrarr arr arrarrarr arra arra arra arra arrarrarraarra arraarra arraarra arra arra araara ara ara ara ara ara ara araara araara araara araara raar a raar a raara raara raara raara raara raar a raar a raar a raar a raar a raar a raaraaaaaaaaaaaaaa aa aa aa aaaaaaaaaa aaaa aa aa aa aaaaaa aa aa aa aaaaaa aa aa aa aaaaaa aa aa aa aaaaaa aa aa aa aaaaaa aa aaaa... 🧵 🧵 🧵 🧵 🧵🧵 🧵🧵 🧵 🧵🧵 🧵🧵 🧵🧵 🧵 🧑💻ℹℹℹℹℹℹℹℹℹℹℹ ℹ ℹ ℹ ℹ ℹ ℹ ℹ ℹ ℹ ℹ ℹ ℹ ℹ ℹ ℹ ℹ ℹ ℹ ℹ ℹ  ̄_______  ̄_ _  ̄ _|  ̄ _| | > |
│ │ │ ┌┘ |< | | │ │_│ █▉▀│ │ │ │ █▉▀│ │ │ │ █▉▀│ █▉▀│ █▉▀│ █▉▀│ █▉▀│ █▉▀│ █▉▀│ █▉▀│ █| █| █| █| │ __ __ _ _ __ _ __ _____ ____ ____ _____ _
/ _ \ / _ \ / __| / __| / _ \ | | | | | || | / ___| ___ \ | |__| ___ || || ||
__ /\___ \ ___) || (__ || ___ || || | ||
\___||____|\____||____||____||____||__|\_\|
_/ |
\ \ / /
/ \
| /
/ /
||__|
/ /
||__|
\/ \
\_/
\_/
\\/\/
_/ //
////
////
\/\\
\
\\\//
///\\\
\_//
/_/
/\/\/
_\/
/\/\/
\_/
---
完成所有安裝步驟之後就可以開始使用了~ 下載完畢後接著就開始進行使用吧!
