import pandas as pd
data= pd. read_excel( 'a.xlsx' , skiprows= 7 ) [ 'Temperature' ]
import pandas as pd
date= pd. read_excel( 'H:/249.xlsx' )
print ( date. shape)
print ( date. columns)
print ( date. head( 3 ) )
print ( '=============' )
print ( date. tail( ) )
== == == == == == == == == == == == == == == == == == == == == == == == == == == =
date= pd. read_excel( 'H:/249.xlsx' , header= 1 )
print ( date. columns)
== == == == == == == == == == == == == == == == == == == == == == == == == == == == == ==
d= { 'x' : 100 , 'y' : 200 , 'z' : 300 }
print ( d. keys( ) )
print ( d. values( ) )
print ( d[ 'x' ] )
s1= pd. Series( d)
print ( s1)
L1= [ 100 , 200 , 300 ]
L2= [ 'x' , 'y' , 'z' ]
s1= pd. Series( [ 100 , 200 , 300 ] , index= [ 'x' , 'y' , 'z' ] )
== == == == == == == == == == == == == == == == == == == == == == == == == == == == == == == == == == ==
pd. read_excel( io, sheetname= 0 , header= 0 , skiprows= None , index_col= None , names= None ,
arse_cols= None , date_parser= None , na_values= None , thousands= None ,
convert_float= True , has_index_names= None , converters= None , dtype= None ,
true_values= None , false_values= None , engine= None , squeeze= False , ** kwds)
== == == == == == == == == == == == == == == == == == == == == == == == == == == == == == == == == == ==
import pandas as pd
path = 'G:\动力系\新建文件夹\什么.xls'
data = pd. DataFrame( pd. read_excel( path) )
print ( data. index)
print ( data. columns)
print ( data[ '姓名' ] )
print ( data. loc[ 0 ] )
== == == == == == == == == == == == == == == == == == == == == == == == == == == == == == == == == == ==
a= [ 1 , 2 , 3 ]
p= a. index( 3 )
print ( p)
== == == == == == == == == == == == == == == == == == == == == == == == == == == == == == == == == == ==
import pandas as pd
import numpy as np
io= "H:/249.xlsx"
date= pd. read_excel( io)
a= np. array( date[ '蓝球' ] )
== == == == == == == == == == == == == == == == == == == == == == == == == == == == == == == == == == ==
读取excel中蓝球号码并输出每个号码的位置完整代码
import pandas as pd
import numpy as np
io= "H:/249.xlsx"
date= pd. read_excel( io)
a= pd. Series( date[ '蓝球' ] )
输出结果为
1 [ 36 , 43 , 44 , 46 , 48 , 49 , 55 , 65 , 91 , 98 , 100 , 104 , 147 , 157 , 164 , 165 , 182 , 190 , 193 , 206 , 208 , 209 , 245 , 248 ]
2 [ 8 , 10 , 38 , 39 , 53 , 67 , 78 , 110 , 150 , 185 , 188 , 189 , 203 , 205 , 213 ]
3 [ 5 , 6 , 16 , 25 , 26 , 35 , 40 , 76 , 77 , 85 , 126 , 146 , 156 , 161 , 226 , 229 , 230 , 232 , 233 , 242 ]
4 [ 4 , 29 , 42 , 70 , 73 , 75 , 86 , 89 , 94 , 118 , 128 , 135 , 139 , 142 , 145 , 172 , 201 ]
for i in range ( 0 , 17 ) :
b= [ ]
for index, nums in enumerate ( a) :
if nums == i:
b. append( index)
print ( i, b, '\n' )
== == == == == == == == == == == == == == == == == == == == == == == == == == == == == == == == ==
list = [ 1 , 2 , 1 , 2 , 3 , 3 , 4 , 5 , 4 ]
print ( list )
set1= set ( list )
print ( set1)
print ( len ( set1) )
== == == == == == == == == == == == == == == == == == == == == == == == == == == == == == == == == == == == =
a = [ 1 , 3 , 5 , 1 , 4 , 3 , 2 , 1 , 2 , 5 , 1 ]
b= [ ]
for index, nums in enumerate ( a) :
if nums == 1 :
b. append( index)
print ( b)
c= [ j+ 1 for j in b]
print ( c)
d= [ ]
for k in c:
if k < len ( a) :
va= a[ k]
d. append( va)
print ( d)
== == == == == == == == == == == == == == == == == == == == == == == == == == == == == == == == =
f= open ( "o1.txt" , "w" )
print ( b/ a, file = f)
== == == == == == == == == == == == == == == == == == == == == == == == == == == == == == == == =
from collections import Counter
count= collections. Counter( list )
e= Counter( a)
count1 = sorted ( e. keys( ) )
count= [ e[ m] for m in count1]
print ( count)
== == == == == == == == == == == == == == == == == == == == == ==
import pandas as pd
import numpy as np
from collections import Counter
f= open ( r'一次转移次数.txt' , 'w' )
io= "H:/正式数据.xlsx"
date= pd. read_excel( io)
a= pd. Series( date[ '蓝球' ] )
for i in range ( 0 , 3 ) :
b= [ ]
c= [ ]
d= [ ]
for index, nums in enumerate ( a) :
if nums == i:
b. append( index)
c= [ j+ 1 for j in b]
for k in c:
if k < len ( a) :
va= a[ k]
d. append( va)
f. close( )
== == == == == == == == == == == == == == == == == == == == == == == == == == == == == == == == == == =