摘要:ref: Structured Query Language (SQL) ref: Inner Join vs Outer Join ref: SQL Self Join ref: SQL | Functions (Aggregate and Scalar Functions) ref: SQL |
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要: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:
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要:In Python's datetime library, you can format dates using the strftime() method. This method allows you to create a formatted string representation of
阅读全文
摘要: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
阅读全文
摘要:ref: Airtable automation trigger: When record created ref: How to export data from Airtable The "When record created" trigger is triggered whenever a
阅读全文
摘要:ref: Read Data from Google Sheets into Pandas without the Google Sheets API import pandas as pd sheet_id = "1XqOtPkiE_Q0dfGSoyxrH730RkwrTczcRbDeJJpqRB
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要:To concatenate (merge) multiple dictionaries in Python, you can use various methods depending on your Python version and preferences. Here are some co
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要:In Pandas, you can filter a DataFrame using logical operations to select rows that meet specific conditions. You can use logical operators such as & (
阅读全文
摘要: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
阅读全文
摘要: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)
阅读全文
摘要:ref: Parallel Processing Factor (Environment setting) ref: Write geoprocessing output to memory Parallel processing arcpy.env.parallelProcessingFactor
阅读全文
摘要: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
阅读全文