kodingwindow@kw:~$ python3 kw.py
account_no name city dob bank amount
0 25622348989 James Moore Phoenix 1985-05-26 Barclays 5000
1 25622348990 Donald Taylor Irvine 1990-08-20 Citi 7000
2 25622348991 Edward Parkar Irvine 1994-01-29 ICICI 95000
3 25622348992 Ryan Bakshi Mumbai 1982-01-14 Citi 50000
4 25622348993 Marie Peters Ribe 1967-01-05 DZBank 12250
5 25622348994 Aanya Delhi 1975-08-18 SBI 105000
6 25622348995 James Moore NaN 1978-06-26 Citi 97800
Python Pandas to create a DataFrame from Excel spreadsheet
kw.xlsx
+------------+---------------+---------+------------+----------+--------+
| account_no | name | city | dob | bank | amount |
+------------+---------------+---------+------------+----------+--------+
| 2562348989 | James Moore | Phoenix | 1985-05-26 | Barclays | 5000 |
| 2562348990 | Donald Taylor | Irvine | 1990-08-20 | Citi | 7000 |
| 2562348991 | Edward Parkar | Irvine | 1994-01-29 | ICICI | 95000 |
| 2562348992 | Ryan Bakshi | Mumbai | 1982-01-14 | Citi | 50000 |
| 2562348993 | Marie Peters | Ribe | 1967-01-05 | DZ Bank | 12250 |
| 2562348994 | Aanya | Delhi | 1975-08-18 | SBI | 105000 |
| 2562348995 | James Moore | | 1978-06-26 | Citi | 97800 |
+------------+---------------+---------+------------+----------+--------+
kodingwindow@kw:~$ python3 kw.py
account_no name city dob bank amount
0 25622348989 James Moore Phoenix 1985-05-26 Barclays 5000
1 25622348990 Donald Taylor Irvine 1990-08-20 Citi 7000
2 25622348991 Edward Parkar Irvine 1994-01-29 ICICI 95000
3 25622348992 Ryan Bakshi Mumbai 1982-01-14 Citi 50000
4 25622348993 Marie Peters Ribe 1967-01-05 DZBank 12250
5 25622348994 Aanya Delhi 1975-08-18 SBI 105000
6 25622348995 James Moore NaN 1978-06-26 Citi 97800
Python Pandas to create a DataFrame from Dictionary
kodingwindow@kw:~$ python3 kw.py
account_no name city dob bank amount
0 25622348989 James Moore Phoenix 1985-05-26 Barclays 5000
1 25622348990 Donald Taylor Irvine 1990-08-20 Citi 7000
2 25622348991 Edward Parkar Irvine 1994-01-29 ICICI 95000
3 25622348992 Ryan Bakshi Mumbai 1982-01-14 Citi 50000
4 25622348993 Marie Peters Ribe 1967-01-05 DZBank 12250
5 25622348994 Aanya Delhi 1975-08-18 SBI 105000
6 25622348995 James Moore NaN 1978-06-26 Citi 97800
Python Pandas to create a DataFrame from List of Tuples
kodingwindow@kw:~$ python3 kw.py
account_no name city dob bank amount
0 25622348989 James Moore Phoenix 1985-05-26 Barclays 5000
1 25622348990 Donald Taylor Irvine 1990-08-20 Citi 7000
2 25622348991 Edward Parkar Irvine 1994-01-29 ICICI 95000
3 25622348992 Ryan Bakshi Mumbai 1982-01-14 Citi 50000
4 25622348993 Marie Peters Ribe 1967-01-05 DZBank 12250
5 25622348994 Aanya Delhi 1975-08-18 SBI 105000
6 25622348995 James Moore NaN 1978-06-26 Citi 97800
Dear User, Thank you for visitng Kodingwindow. If you are interested in technical articles, latest technologies, and our journey further, please follow us on LinkedIn.
Dear User, We are grateful for your interest in the Kodingwindow Android app. We intend to soon make it available on the Google Play Store. Currently, Android versions 10 and up require manual apk installations. Would you like to get the app?