LogIn E-mail
¼³°èÀ̾߱â
pandas ¼¿ isna isnull notna notnull
# 45 JMJS    24.1.28 15:35

import pandas as pd
import numpy  as np

col  = [ 'col1','col2', 'col3' ,'col4']
row  = [ 'row1','row2', 'row3' ]
data = [[    1 ,    2 ,  pd.NA ,    4 ],
        [np.nan,    6 , np.inf ,    8 ],
        [    9 ,  ' ' ,     '' , None ]]

df = pd.DataFrame(data,row,col)

print(df,'\n')
#      col1  col2  col3  col4
#row1   1.0     2  <NA>   4.0
#row2   NaN     6   inf   8.0
#row3   9.0               NaN

print(' isna',df.isnull(),'\n')  #  isna ==  isnull
# isna  col1   col2   col3   col4
#row1  False  False   True  False
#row2   True  False  False  False
#row3  False  False  False   True

print('notna',df.notna() ,'\n')  # notna == notnull
#notna  col1  col2   col3   col4
#row1   True  True  False   True
#row2  False  True   True   True
#row3   True  True   True  False

df.at['row4','col5']=45
df.at['row5','col7']=57
print(df,'\n')
#      col1 col2  col3  col4  col5  col7
#row1   1.0    2  <NA>   4.0   NaN   NaN
#row2   NaN    6   inf   8.0   NaN   NaN
#row3   9.0              NaN   NaN   NaN
#row4   NaN  NaN   NaN   NaN  45.0   NaN
#row5   NaN  NaN   NaN   NaN   NaN  57.0

print('  index:',df.index,'\n')
#  index: Index(['row1', 'row2', 'row3', 'row4', 'row5'], dtype='object')

print('columns:',df.columns,'\n')
#columns: Index(['col1', 'col2', 'col3', 'col4', 'col5', 'col7'], dtype='object')

°Ô½Ã¹°: 61 °Ç, ÇöÀç: 1 / 1 ÂÊ
¹øÈ£ Á¦       ¸ñ ÀÛ¼ºÀÚ µî·ÏÀÏ ¹æ¹®
61  os.path.dirname(os.path.realpath(__file__))) JMJS 25.8.20 132
60  img2rgb.py PIL lambda print end prn sys.argv JMJS 24.6.18 442
59  cv2 image pixel bgr °ª ¼öÁ¤Çϱâ JMJS 24.3.1 449
58  ±ÛÀÚÇǶó¹Ìµå lpyramid.py JMJS 24.3.1 475
57  µñ¼Å³Ê¸® dictionary µñ¼Å³Ê¸® key¿Í value µÚÁý±â ... JMJS 24.3.1 396
56  bus idx2set cap JMJS 24.2.22 452
55  ÆÄÀ̽㠸®½ºÆ®¿¡¼­ ºó ¹®ÀÚ¿­ÀÎ ¿ø¼Ò Á¦°ÅÇϱâ JMJS 24.2.22 434
54  openpyxl JMJS 24.2.22 427
53  Decorators µ¥ÄÚ·¹ÀÌÅÍ JMJS 24.2.29 462
52  walrus operator := and for in list JMJS 24.2.1 426
51  pandas Çà Ãß°¡ JMJS 24.1.28 376
50  split with brackets JMJS 24.1.27 386
49  ÀÌÅÍ·¹ÀÌÅÍ Iterator JMJS 24.1.26 429
48  re regular expression JMJS 24.1.26 388
47  read_excel()ÀÇ ÁöÁ¤ °¡´ÉÇÑ ¿É¼Ç JMJS 24.1.26 426
46  pandas to_excel sheet ¿©·¯Àå excel ÆÄÀÏ ¾²±â Àбâ JMJS 24.1.28 508
45  pandas ¼¿ isna isnull notna notnull JMJS 24.1.28 455
44  tkinter tk1.py JMJS 24.1.25 508
43  pandas _append df2.py JMJS 24.1.25 467
42  ÆÇ´Ù½º pandas DataFrame, list, dictionary, ... JMJS 24.1.25 477
41  f-string JMJS 24.6.18 488
40  pandas JMJS 24.1.17 382
39  __add__ __getattr__ __getitem__ __setitem__ JMJS 24.1.24 439
38  ÆÄÀ̽㠼³Ä¡°æ·Î È®ÀÎ JMJS 23.12.4 387
37  deepcopy JMJS 23.11.24 405
36  def func(*args): JMJS 23.11.24 456
35  sys.version_info JMJS 23.11.19 438
34  argparse add_argument parse_args JMJS 24.1.17 391
33  [bpy]bone2_wr.py JMJS 23.9.23 437
32  [bpy]bm.verts depsgraph JMJS 23.9.23 396
31  [bpy]keyframe_insert JMJS 23.9.23 407
30  [bpy]key_blocks JMJS 23.9.23 412
29  def abc (a=10,b=20,c=30) JMJS 23.8.1 413
28  shape prj JMJS 23.10.29 477
27  yaml JMJS 23.11.30 476
26  getopt arg argv JMJS 23.7.26 456
25  pg.mouse.get_pressed() pg.mouse.get_pos() JMJS 22.11.20 587
24  pg.MOUSEBUTTONDOWN event.button JMJS 22.11.20 582
23  ¸ðµÎÀÇ ÆÄÀ̽ã - 20Àϸ¸¿¡¹è¿ì´Â ÇÁ·Î±×·¡¹Ö ±âÃÊ JMJS 20.1.8 625
22  python -m pip install -U pip JMJS 19.11.25 535
21  get =lambda i,m ... JMJS 19.11.13 607
20  2Â÷¿ø ¸®½ºÆ®, Æ©Çà JMJS 19.11.13 593
19  [turtle]def polygon3(n,c,d) JMJS 19.11.11 618
18  [turtle]def polygon2(n,a) JMJS 19.11.11 628
17  def factorial(n) JMJS 19.11.11 536
16  def sum_func(n) JMJS 19.11.11 536
15  def hello() fun1(a) fun2(a,b) JMJS 19.11.11 535
14  while sum JMJS 19.11.11 619
13  random calculation JMJS 19.11.11 527
12  turtle random JMJS 19.11.11 530
11  import time time.time JMJS 19.11.11 641
10  turtle begin_fill end_fill JMJS 19.11.11 527
9  if else JMJS 19.11.11 535
8  input JMJS 19.11.11 534
7  list JMJS 24.3.1 642
6  turtle triangle JMJS 19.11.11 568
5  for range JMJS 19.11.11 546
4  ¸ðµâ »ç¿ëÇϱâ JMJS 19.11.11 589
3  import ÆÄÀ̽㠸ðµâ °¡Á®´Ù ¾²±â JMJS 19.11.11 589
1  print ÁÙ¹Ù²Þ JMJS 19.11.11 601
 ^_^ 70.1.1
[1]