質問編集履歴
1
簡潔になるよう修正しました
test
CHANGED
@@ -1 +1 @@
|
|
1
|
-
pandas2次元データ(pd.Series)をpandas3次元データ(pd.Panel)に入れ
|
1
|
+
pandas2次元データ(pd.Series)をpandas3次元データ(pd.Panel)に入れられずに困っています
|
test
CHANGED
@@ -2,72 +2,16 @@
|
|
2
2
|
|
3
3
|
|
4
4
|
|
5
|
-
ちなみに、以下のコードの中で、一番したの箇所になります。
|
6
|
-
|
7
|
-
df[i].iloc[:,:] = temp_df.loc[:,['X','Y']]
|
8
5
|
|
9
6
|
|
7
|
+
ここに言語を入力
|
10
8
|
|
11
|
-
######################
|
12
|
-
|
13
|
-
|
14
|
-
|
15
|
-
|
9
|
+
```
|
16
|
-
|
17
|
-
import os.path
|
18
|
-
|
19
|
-
import glob
|
20
|
-
|
21
|
-
import re
|
22
|
-
|
23
|
-
import openpyxl as px
|
24
|
-
|
25
|
-
|
26
|
-
|
27
|
-
temp_list=os.listdir("")
|
28
|
-
|
29
|
-
list_dir=sorted(temp_list,key=lambda s:int(s.split(')')[0]))
|
30
10
|
|
31
11
|
df=pd.Panel(np.zeros([len(list_dir),50000,2]))
|
32
12
|
|
33
13
|
for i in range(len(list_dir)):
|
34
14
|
|
35
|
-
p
|
15
|
+
df[i].iloc[:,:] = temp_df.loc[:,['X','Y']]
|
36
16
|
|
37
|
-
path2=list_dir[i]
|
38
|
-
|
39
|
-
path3='**.xlsx'
|
40
|
-
|
41
|
-
path=os.path.join(path1,path2,path3)
|
42
|
-
|
43
|
-
name_file=glob.glob(path)
|
44
|
-
|
45
|
-
for j in range(len(name_file)):
|
46
|
-
|
47
|
-
print('dir ',i,' file ',j)
|
48
|
-
|
49
|
-
xlsx = pd.ExcelFile(name_file[j])
|
50
|
-
|
51
|
-
if j==0:
|
52
|
-
|
53
|
-
tempX_df = pd.read_excel(xlsx, sheetname='A')
|
54
|
-
|
55
|
-
temp_df = tempX_df.loc[:,['X','Y']]
|
56
|
-
|
57
|
-
|
17
|
+
```
|
58
|
-
|
59
|
-
wb=px.load_workbook(name_file[j])
|
60
|
-
|
61
|
-
sheetnames=wb.get_sheet_names()
|
62
|
-
|
63
|
-
if 'A' in sheetnames:
|
64
|
-
|
65
|
-
tempX_df = pd.read_excel(xlsx, sheetname='A')
|
66
|
-
|
67
|
-
elif 'Sheet1' in sheetnames:
|
68
|
-
|
69
|
-
tempX_df = pd.read_excel(xlsx, sheetname='Sheet1')
|
70
|
-
|
71
|
-
temp_df = pd.concat([temp_df,tempX_df.loc[:,['X','Y']]])
|
72
|
-
|
73
|
-
df[i].iloc[:,:] = temp_df.loc[:,['X','Y']]
|