Table 2 Selected variables during customization each for predicting ciprofloxacin (CIP) resistance and ESBL positivity with data distribution.

From: Machine learning model for predicting ciprofloxacin resistance and presence of ESBL in patients with UTI in the ED

Selected variables

Training sets (2020)

Testing sets (2021)

CIP-susceptible (n = 228)

CIP-resistant (n = 195)

CIP-susceptible (n = 66)

CIP-resistant (n = 61)

Mean (SD)

Missing rate (%)

Mean (SD)

Missing rate (%)

Mean (SD)

Missing rate (%)

Mean (SD)

Missing rate (%)

Hospital-acquired (%)

7.5

0

31.8

0

3.0

0

39.3

0

Bedridden (%)

23.2

0

53.8

0

16.7

0

63.9

0

1y-UTI

14.5

1.8

37.9

0.4

6.1

0.4

31.1

0.4

DBP

74.8(18.1)

0

70.3(17.1)

0

74.4(17.9)

0

73.3(18.5)

0

Platelet

202.2(99.4)

0

222.7(100.2)

0

197.5(107.9)

0

208.9(99.3)

0

BT

38.2(1.2)

0

37.7(1.2)

0

43.2(43.1)

0

37.4(1.1)

0

pCO2

32.9(7.3)

18.0

33.2(6.8)

6.6

34.5(6.9)

6.1

35.5(6.8)

1.3

Creatinine

1.3(1.6)

0

1.5(1.2)

0

1.2(0.8)

0

1.2(0.8)

0

SpO2

95.6(5.8)

4.8

95.0(4.1)

1.8

97.0(3.0)

1.3

96.3(2.6)

0.9

SaO2

95.0(4.1)

6.6

93.6(6.9)

1.8

110.2(113.1)

3.1

94.7(3.6)

1.3

3 m-admission (%)

24.1

1.3

51.3

0.4

13.6

0.4

60.7

0.4

Cerebrovascular (%)

31.1

0

54.9

0

40.9

0

54.1

0

HCO3

22.8(4.7)

18.0

23.6(7.8)

6.6

23.9(4.2)

6.1

25.6(10.8)

1.3

SBP

129.9(29.9)

0

123.8(30.0)

0

130.3(28.9)

0

128.0(35.2)

0

3 m-antibiotics (%)

15.4

1.8

32.8

0.4

7.6

0.4

37.7

0.4

WBC

11,751.0 (5875.1)

0

12,640.6 (7263.6)

0

11,760.9 (6988.1)

0

11,204.1 (5453.1)

0

Mental change (%)

18.9

0

23.1

0

7.6

0

34.4

0

PR

100.3(21.3)

0

96.3(22.0)

0

99.3(23.2)

0

92.7(22.9)

0

pH

47.4(546.6)

18.0

48.7(553.7)

6.6

7.4(0.1)

6.1

7.4(0.1)

1.3

Glucose

171.6(98.9)

0

160.9(85.1)

0

145.1(64.3)

0

175.4(125.5)

0

Selected variables

Training sets (2020)

Testing sets (2021)

ESBL negative (n = 225)

ESBL positive (n = 198)

ESBL negative (n = 70)

ESBL positive (n = 57)

Mean (SD)

Missing rate (%)

Mean (SD)

Missing rate (%)

Mean (SD)

Missing rate (%)

Mean (SD)

Missing rate (%)

3 m-admission (%)

19.6

0.4

56.1

1.5

15.7

2.9

61.4

0

3 m-antibiotic (%)

9.8

0.9

38.9

1.5

8.6

2.9

38.6

0

Bedridden (%)

22.7

0

54.0

0

18.6

0

64.9

0

Cerebrovascular (%)

29.3

0

56.6

0

35.7

0

61.4

0

BUN

28.8(64.6)

0

29.7(21.6)

0

25.3(20.3)

0

25.3(14.2)

0

  1. SD, standard deviation; 1y-UTI, UTI within a year; DBP, diastolic blood pressure; BT, body temperature; SpO2, peripheral oxygen saturation; SaO2, arterial oxygen saturation; 3 m-admission, hospitalization within 3 months; SBP, systolic blood pressure; 3 m-antibiotics, antibiotics use within 3 months; WBC, leukocyte count; PR, pulse rate.