Table of Contents
Name | Direction | Type | Default | Description |
---|---|---|---|---|
UpdateFile | Input | string | Mandatory | The cal file containing the updates to merge into another file. Allowed values: [‘cal’] |
MasterFile | Input | string | Mandatory | The master file to be altered, the file must be sorted by UDET. Allowed values: [‘cal’] |
OutputFile | Input | string | Mandatory | The file to contain the results. Allowed values: [‘cal’] |
MergeOffsets | Input | boolean | False | If True, the offsets from file1 will be merged to the master file. Default: False |
MergeSelections | Input | boolean | False | If True, the selections from file1 will be merged to the master file. Default: False |
MergeGroups | Input | boolean | False | If True, the Groups from file1 will be merged to the master file. Default: False |
Combines the data contained in two cal files, based on the selections offsets, selections and groups can be merged. The matching rows are determined by UDET. Any unmatched records are added at the end of the file.
Example - Merging and appending files
import os
#find a suitable directory to save the files
file_dir = config["defaultsave.directory"]
if not os.path.isdir(file_dir):
#use the users home directory if default save is not set
file_dir = os.path.expanduser('~')
def writeCalFile(file_name,num_dets,inc_group=True,inc_offset=True,inc_selected=True):
file_path = os.path.join(file_dir,file_name+".cal")
#write the cal file out
with open(file_path, "w") as file:
for line_no in range(num_dets):
file.write("%i\t%i\t%f\t%i\t%i\n" %
(line_no,
line_no + 100,
(line_no / 1000.0) if inc_offset else 0.0,
(line_no % 2) if inc_selected else 0,
(line_no % 3) if inc_group else 1) )
return file_path
calFile_master = writeCalFile("masterCal",6)
calFile_updates = writeCalFile("updateCal",3,
inc_group=False, inc_offset=False, inc_selected=False)
output_file = os.path.join(file_dir,"output.cal")
MergeCalFiles(
UpdateFile = calFile_updates,
MasterFile = calFile_master,
OutputFile = output_file,
MergeOffsets = True,
MergeSelections = True,
MergeGroups = True)
#Load and print the resulting file
print "The result file has been updated with 0 for group, select and offset\nwhere the detector id's match"
with open(output_file, "r") as file:
print file.read().rstrip()
#cleanup
os.remove(calFile_master)
os.remove(calFile_updates)
os.remove(output_file)
Output:
The result file has been updated with 0 for group, select and offset
where the detector id's match
0 100 0.0000000 0 1
1 101 0.0000000 0 1
2 102 0.0000000 0 1
3 103 0.0030000 1 0
4 104 0.0040000 0 1
5 105 0.0050000 1 2
Example - Appending files
import os
#find a suitable directory to save the files
file_dir = config["defaultsave.directory"]
if not os.path.isdir(file_dir):
#use the users home directory if default save is not set
file_dir = os.path.expanduser('~')
def writeCalFile(file_name,num_dets,inc_group=True,inc_offset=True,inc_selected=True):
file_path = os.path.join(file_dir,file_name+".cal")
#write the cal file out
with open(file_path, "w") as file:
for line_no in range(num_dets):
file.write("%i\t%i\t%f\t%i\t%i\n" %
(line_no,
line_no + 100,
(line_no / 1000.0) if inc_offset else 0.0,
(line_no % 2) if inc_selected else 0,
(line_no % 3) if inc_group else 1) )
return file_path
calFile_master = writeCalFile("masterCal",6)
calFile_updates = writeCalFile("updateCal",8,
inc_group=False, inc_offset=False, inc_selected=False)
output_file = os.path.join(file_dir,"output.cal")
MergeCalFiles(
UpdateFile = calFile_updates,
MasterFile = calFile_master,
OutputFile = output_file,
MergeOffsets = False,
MergeSelections = False,
MergeGroups = False)
#Load and print the resulting file
print "Any additional rows in the update file will be added,\nset the Merge options to False if you don't want to affect existing values"
with open(output_file, "r") as file:
print file.read().rstrip()
#cleanup
os.remove(calFile_master)
os.remove(calFile_updates)
os.remove(output_file)
Output:
Any additional rows in the update file will be added,
set the Merge options to False if you don't want to affect existing values
0 100 0.0000000 0 0
1 101 0.0010000 1 1
2 102 0.0020000 0 2
3 103 0.0030000 1 0
4 104 0.0040000 0 1
5 105 0.0050000 1 2
6 106 0.0000000 0 1
7 107 0.0000000 0 1
Categories: Algorithms | DataHandling | Text | Diffraction | PythonAlgorithms
Python: MergeCalFiles.py