Matplotlib Learning Notes - Part 4 (Converting Excel Data to Matplotlib)

Matplotlib Learning Notes - Part 4 (Converting Excel Data to Matplotlib)

This is the Excel worksheet I am going to convert to Matplotlib.

I am using python dictionary to store the tunnel diode I-V measurements.  First step is to just copy the cells and paste to Chinese Win10 Notebook:

Plotting I-V Curve of Tunnel Diode 2BS4 Sample #1, v0.2 tlfong01  2020nov24hkt1346

Step Vt (mV) It (mA) Remark

1 0.10 0.02 Before Negative Resistance Region

2 0.20 0.02

3 0.30 0.03

4 0.40 0.05

5 0.50 0.06

6 1.00 0.11

7 2.00 0.24

8 3.00 0.34

9 4.00 0.46

10 5.00 0.57

11 6.00 0.80

12 7.00 0.78

13 9.00 1.01

14 10.00 1.11

15 11.00 1.21

16 12.00 1.32

17 13.00 1.41

18 14.00 1.51

19 15.00 1.60

20 16.00 1.70

21 194.00 1.88 Negative Resistance Region

22 206.00 1.88

23 221.00 1.88

24 241.00 1.88

25 250.00 1.88

26 271.00 1.88

27 486.00 1.88 After Negative Resistance Region

28 488.00 1.95

29 490.00 2.06

30 492.00 2.15

31 495.00 2.32

32 498.00 2.49

33 500.00 2.63

Next step is to copy and paste the NoteBook data to a  python dictionary, 

and yes, start coding:

Talk is cheap, show me the code - Linus Torvolds

.END