Python 拼接C#字典格式对象

依据一个Excel中的2列创建一个字典格式的数据。

例如：

将这2类字符串复制到文本中，读取文本内容，按行读取，每行按空格分隔。

with open(r'D:\\TestPoint.txt')as f:
    for l in f:
       print(l, end='')
1
2
3

这样就按行读取了数据，使用split方法风格。

with open(r'D:\\TestPoint.txt')as f:
        for l in f:
            temp = l.split()
            print("{", '"', temp[0], '"', ',"', temp[1], '"}', ',')
1
2
3
4

输出格式如下：

{ " 2302 " ," A "} ,
{ " 2303 " ," B "} ,
{ " 2304 " ," C "} ,
{ " 2305 " ," RLED "} ,
{ " 2306 " ," YLED "} ,
{ " 2307 " ," BAT "} ,
{ " 2308 " ," TEM-1 "} ,
{ " 2309 " ," Current "} 
1
2
3
4
5
6
7
8

也使用名称为字典的键，更换位置即可：

print("{", '"', temp[1], '"', ',"', temp[0], '"}', ',')
1

输出：

{ " A " ," 2302 "} ,
{ " B " ," 2303 "} ,
{ " C " ," 2304 "} ,
{ " RLED " ," 2305 "}
1
2
3
4

也可以使用TestPointDataID为主键，自建自增变量为值

i =0
with open(r'D:\\TestPoint.txt')as f:
    for l in f:
         temp = l.split()
         print("{" +'"' + temp\[0\] +'"' +',' +str(i), '}' +',')
        i = i +1
1
2
3
4
5
6

输出：

{"2302",0 },
{"2303",1 },
{"2304",2 },
{"2305",3 },
{"2306",4 },
{"2307",5 },
{"2308",6 }
1
2
3
4
5
6
7

在C#中创建字典，直接将输出的字典格式复制过去即可，依据需求可设置键和值的类型：

Dictionary<string, int> TestPointIndex\_Dict = new Dictionary<string, int>()
        {
                {"2302",0 },
                {"2303",1 },
                {"2304",2 },
                {"2305",3 },
                {"2306",4 },
                {"2307",5 },
                {"2308",6 },
                {"2309",7 }
    }
1
2
3
4
5
6
7
8
9
10
11