alex_bn_lee

导航

< 2025年2月 >
26 27 28 29 30 31 1
2 3 4 5 6 7 8
9 10 11 12 13 14 15
16 17 18 19 20 21 22
23 24 25 26 27 28 1
2 3 4 5 6 7 8

统计

10 2023 档案

[928] SQL Tutorial
摘要:ref: Structured Query Language (SQL) ref: Inner Join vs Outer Join ref: SQL Self Join ref: SQL | Functions (Aggregate and Scalar Functions) ref: SQL | 阅读全文

posted @ 2023-10-27 12:41 McDelfino 阅读(11) 评论(0) 推荐(0) 编辑

[927] Batch script related
摘要:ref: Batch Script - Quick Guide ref: Batch Script - Syntax ECHO Command @echo off By default, a batch file will display its command as it runs. The pu 阅读全文

posted @ 2023-10-25 08:48 McDelfino 阅读(16) 评论(0) 推荐(0) 编辑

[926] Batch Script - Commands
摘要:In this chapter, we will look at some of the frequently used batch commands. S.No Commands & Description 1 VER This batch command shows the version of 阅读全文

posted @ 2023-10-24 14:10 McDelfino 阅读(7) 评论(0) 推荐(0) 编辑

[925] GDA2020_MGA and change the spatial reference in ArcGIS Pro
摘要:ZONE50: 114.0 120.0 - arcpy.mp.spatialReference("GDA2020_MGA_Zone_50") ZONE51: 120.0 126.0 - arcpy.mp.spatialReference("GDA2020_MGA_Zone_51") ZONE52: 阅读全文

posted @ 2023-10-24 11:40 McDelfino 阅读(15) 评论(0) 推荐(0) 编辑

[924] ArcGIS Pro Mapping Module - arcpy.mp
摘要:ref: Introduction to arcpy.mp ref: Getting started with arcpy.mp tutorial ref: Guidelines for arcpy.mp ref: Alphabetical list of arcpy.mp functions re 阅读全文

posted @ 2023-10-24 10:04 McDelfino 阅读(37) 评论(0) 推荐(0) 编辑

[923] f-strings in Python
摘要:ref: f-strings in Python ref: Python's F-String for String Interpolation and Formatting F-strings, also known as formatted string literals, are a feat 阅读全文

posted @ 2023-10-23 12:36 McDelfino 阅读(12) 评论(0) 推荐(0) 编辑

[922] Implementation of zooming to selected features by Python
摘要:ref: ArcPy.mp Get Selected Features Extent ref: Python/ArcPy classes/Geometry # Set the path to your project file (.aprx) project_file = r"Map 1.3 Her 阅读全文

posted @ 2023-10-20 14:29 McDelfino 阅读(9) 评论(0) 推荐(0) 编辑

[921] Replace texts, copy formats, align paragraphs in a Word document by Python
摘要:The whole steps of this function are as follows: Open the Word document. Replace the text with the new text. Copy the format from the source cell to t 阅读全文

posted @ 2023-10-20 10:32 McDelfino 阅读(5) 评论(0) 推荐(0) 编辑

[920] Copy the font style from one cell in a table of a Word document to another cell using Python
摘要:To copy the font style from one cell in a table of a Word document to another cell using Python and the python-docx library, you can access the font p 阅读全文

posted @ 2023-10-20 09:59 McDelfino 阅读(46) 评论(0) 推荐(0) 编辑

[919] Change the horizontal alignment of a cell to center within a table of a Word document using Python
摘要:To change the horizontal alignment of a cell to center within a table of a Word document using Python and the python-docx library, you can set the ali 阅读全文

posted @ 2023-10-20 09:57 McDelfino 阅读(33) 评论(0) 推荐(0) 编辑

[918] Copy the formatting from one cell in a table of a Word document to another cell in Python
摘要:To copy the formatting from one cell in a table of a Word document to another cell, you can use the python-docx library in Python. Here's a step-by-st 阅读全文

posted @ 2023-10-20 09:55 McDelfino 阅读(89) 评论(0) 推荐(0) 编辑

[917] Replace text in a specific table within a Word document using Python
摘要:To replace text in a specific table within a Word document using Python, you can use the python-docx library to access and modify the content of the t 阅读全文

posted @ 2023-10-20 09:53 McDelfino 阅读(94) 评论(0) 推荐(0) 编辑

[916] Replace text in a Word document using Python
摘要:To replace text in a Word document using Python, you can use the python-docx library, which allows you to work with Microsoft Word files (.docx). If y 阅读全文

posted @ 2023-10-20 09:51 McDelfino 阅读(56) 评论(0) 推荐(0) 编辑

[915] Implementation of zooming to layer and exporting to PDF in arcpy
摘要:ref: Camera - ArcGIS Pro ref: Introduction to arcpy.mp # Set the path to your project file (.aprx) project_file = r"Map 1.3 Heritage.aprx" # Reference 阅读全文

posted @ 2023-10-20 09:48 McDelfino 阅读(6) 评论(0) 推荐(0) 编辑

[914] In Python's datetime library, you can format dates using the strftime() method
摘要:In Python's datetime library, you can format dates using the strftime() method. This method allows you to create a formatted string representation of 阅读全文

posted @ 2023-10-18 13:56 McDelfino 阅读(6) 评论(0) 推荐(0) 编辑

[913] Updating a Table of Contents (TOC) in a Word document using pywin32 to display numbers
摘要:If the python-docx method mentioned earlier doesn't work on your computer, you can try using the pywin32 library, which allows you to interact with Mi 阅读全文

posted @ 2023-10-18 13:53 McDelfino 阅读(177) 评论(0) 推荐(0) 编辑

[912] Airtable automation related stuff
摘要:ref: Airtable automation trigger: When record created ref: How to export data from Airtable The "When record created" trigger is triggered whenever a 阅读全文

posted @ 2023-10-18 13:15 McDelfino 阅读(8) 评论(0) 推荐(0) 编辑

[911] Read Data from Google Sheets into Pandas without the Google Sheets API (.gsheet)
摘要:ref: Read Data from Google Sheets into Pandas without the Google Sheets API import pandas as pd sheet_id = "1XqOtPkiE_Q0dfGSoyxrH730RkwrTczcRbDeJJpqRB 阅读全文

posted @ 2023-10-18 13:10 McDelfino 阅读(8) 评论(0) 推荐(0) 编辑

[910] Copy a file to another directory with a new name in Python
摘要:To copy a file to another directory with a new name in Python, you can use the shutil library. Here's how you can do it: import shutil # Specify the s 阅读全文

posted @ 2023-10-17 13:14 McDelfino 阅读(24) 评论(0) 推荐(0) 编辑

[909] Remove duplicated rows based on multiple columns in Pandas
摘要:In a Pandas DataFrame, you can remove duplicated rows based on multiple columns using the drop_duplicates() method. Here's how you can do it: import p 阅读全文

posted @ 2023-10-17 13:11 McDelfino 阅读(13) 评论(0) 推荐(0) 编辑

[908] Implementation of the progress bar in Python
摘要:You can implement a progress bar in Python to visually represent the progress of a task using various libraries. One commonly used library for this pu 阅读全文

posted @ 2023-10-17 13:09 McDelfino 阅读(17) 评论(0) 推荐(0) 编辑

[907] Merge multiple PDF files into one in Python
摘要:You can merge multiple PDF files into one using various Python libraries. One common approach is to use the PyPDF2 library, which allows you to manipu 阅读全文

posted @ 2023-10-17 13:06 McDelfino 阅读(15) 评论(0) 推荐(0) 编辑

[906] Replace NaN (Not-a-Number) values with 'Null' in Pandas
摘要:In Pandas, you can replace NaN (Not-a-Number) values in a DataFrame with None (Python's None type) or np.nan (NumPy's NaN) values. Here's how you can 阅读全文

posted @ 2023-10-17 13:03 McDelfino 阅读(18) 评论(0) 推荐(0) 编辑

[905] The replace() method in Pandas
摘要:In Pandas, the replace() method is used to replace values in a DataFrame or Series. You can use this method to replace one or more specified values wi 阅读全文

posted @ 2023-10-17 13:01 McDelfino 阅读(30) 评论(0) 推荐(0) 编辑

[904] docxtpl cannot render less than sign (<)
摘要:ref: Cannot render less than sign #447 If the content includes the less than sign (<) or larger than sign (>), it cannot be updated in the Word docume 阅读全文

posted @ 2023-10-11 08:04 McDelfino 阅读(13) 评论(0) 推荐(0) 编辑

[903] Concatenate (merge) multiple dictionaries in Python
摘要:To concatenate (merge) multiple dictionaries in Python, you can use various methods depending on your Python version and preferences. Here are some co 阅读全文

posted @ 2023-10-10 09:09 McDelfino 阅读(6) 评论(0) 推荐(0) 编辑

[902] Get the current file's directory of CMD batch scripts
摘要:In a batch file, you can use the %~dp0 special variable to get the directory of the currently executing batch file. Here's how you can do it: @echo of 阅读全文

posted @ 2023-10-10 09:03 McDelfino 阅读(9) 评论(0) 推荐(0) 编辑

[901] Reuse variables of CMD batch scripts
摘要:In a batch file, you can reuse a variable to generate different file paths by concatenating the variable with other strings or variables. Here's an ex 阅读全文

posted @ 2023-10-10 08:58 McDelfino 阅读(16) 评论(0) 推荐(0) 编辑

[900] Print an empty line of CMD batch scripts
摘要:Use the echo. command to print an empty line. @echo off echo This is a line of text echo. echo This is a new line of text This will produce the output 阅读全文

posted @ 2023-10-10 08:55 McDelfino 阅读(8) 评论(0) 推荐(0) 编辑

[899] Save a dictionary as a file (JSON)
摘要:In Python, you can save a dictionary as a file using various methods, such as JSON, Pickle, or CSV. Here, I'll show you how to save a dictionary as a 阅读全文

posted @ 2023-10-10 08:46 McDelfino 阅读(17) 评论(0) 推荐(0) 编辑

[898] Convert the data type of a DataFrame column
摘要:In Pandas, you can convert the data type of a DataFrame column to a string data type using the .astype() method. Here's how to do it: import pandas as 阅读全文

posted @ 2023-10-10 08:44 McDelfino 阅读(11) 评论(0) 推荐(0) 编辑

[897] Filter a DataFrame using logical operations
摘要:In Pandas, you can filter a DataFrame using logical operations to select rows that meet specific conditions. You can use logical operators such as & ( 阅读全文

posted @ 2023-10-10 08:40 McDelfino 阅读(8) 评论(0) 推荐(0) 编辑

[896] Replace values in a DataFrame
摘要:You can replace values in a Pandas DataFrame using the replace() method or by directly assigning new values to specific DataFrame elements. Here's how 阅读全文

posted @ 2023-10-10 08:36 McDelfino 阅读(6) 评论(0) 推荐(0) 编辑

[895] Sort the rows of a DataFrame
摘要:In Pandas, the sort_values() method is used to sort the rows of a DataFrame by one or more columns. This method allows you to specify which column(s) 阅读全文

posted @ 2023-10-10 08:34 McDelfino 阅读(8) 评论(0) 推荐(0) 编辑

[894] Optimize arcpy scripts
摘要:ref: Parallel Processing Factor (Environment setting) ref: Write geoprocessing output to memory Parallel processing arcpy.env.parallelProcessingFactor 阅读全文

posted @ 2023-10-09 12:50 McDelfino 阅读(5) 评论(0) 推荐(0) 编辑

[893] Add comments at a batch file (CMD)
摘要:ref: How do I do comments at a Windows command prompt? REM is the standard way: REM this is a comment You could also use the double-colon convention c 阅读全文

posted @ 2023-10-09 12:44 McDelfino 阅读(12) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示