In [18]:
import pandas as pd
pd.read_csv("http://172.16.7.54/git_oneline_numstat.log")


Out[18]:
1 1 docs/README.md
0 76\t0\tdocs/README.md
1 290\t0\tdocs/assets/css/style.scss
2 -\t-\tdocs/documentation/images/class-diagram.png
3 1224\t0\tdocs/documentation/index.html
4 -\t-\tdocs/documentation/index.pdf
5 155\t0\tdocs/reports/css/maven-base.css
6 141\t0\tdocs/reports/css/maven-theme.css
7 7\t0\tdocs/reports/css/print.css
8 1\t0\tdocs/reports/css/site.css
9 -\t-\tdocs/reports/images/close.gif
10 -\t-\tdocs/reports/images/collapsed.gif
11 -\t-\tdocs/reports/images/expanded.gif
12 -\t-\tdocs/reports/images/external.png
13 -\t-\tdocs/reports/images/icon_error_sml.gif
14 -\t-\tdocs/reports/images/icon_info_sml.gif
15 -\t-\tdocs/reports/images/icon_success_sml.gif
16 -\t-\tdocs/reports/images/icon_warning_sml.gif
17 -\t-\tdocs/reports/images/logos/build-by-maven...
18 -\t-\tdocs/reports/images/logos/build-by-maven...
19 -\t-\tdocs/reports/images/logos/maven-feather.png
20 -\t-\tdocs/reports/images/newwindow.png
21 1037\t0\tdocs/reports/jqassistant-report.xml
22 805\t0\tdocs/reports/jqassistant.html
23 753\t0\tdocs/reports/structure_LayerDependenci...
24 3114\t0\tdocs/reports/structure_PackageDepende...
25 -\t-\tdocs/screenshots/html-documentation-1.png
26 -\t-\tdocs/screenshots/html-documentation-2.png
27 -\t-\tdocs/screenshots/html-documentation-3.png
28 -\t-\tdocs/screenshots/html-report.png
29 -\t-\tdocs/screenshots/pdf-documentation.png
... ...
3889 12\t0\torg.springframework.samples.petclinic/....
3890 3\t0\torg.springframework.samples.petclinic/.s...
3891 10\t0\torg.springframework.samples.petclinic/....
3892 7\t0\torg.springframework.samples.petclinic/.s...
3893 6\t0\torg.springframework.samples.petclinic/.s...
3894 9\t0\torg.springframework.samples.petclinic/.s...
3895 3\t0\torg.springframework.samples.petclinic/.s...
3896 67\t0\torg.springframework.samples.petclinic/....
3897 13\t0\torg.springframework.samples.petclinic/....
3898 106\t0\torg.springframework.samples.petclinic/...
3899 14\t0\torg.springframework.samples.petclinic/s...
3900 26\t0\torg.springframework.samples.petclinic/s...
3901 36\t0\torg.springframework.samples.petclinic/s...
3902 13\t0\torg.springframework.samples.petclinic/s...
3903 39\t0\torg.springframework.samples.petclinic/s...
3904 5\t0\torg.springframework.samples.petclinic/sr...
3905 25\t0\torg.springframework.samples.petclinic/s...
3906 41\t0\torg.springframework.samples.petclinic/s...
3907 9\t0\torg.springframework.samples.petclinic/sr...
3908 10\t0\torg.springframework.samples.petclinic/s...
3909 9\t0\torg.springframework.samples.petclinic/sr...
3910 5\t0\torg.springframework.samples.petclinic/sr...
3911 42\t0\torg.springframework.samples.petclinic/s...
3912 12\t0\torg.springframework.samples.petclinic/s...
3913 14\t0\torg.springframework.samples.petclinic/s...
3914 36\t0\torg.springframework.samples.petclinic/s...
3915 12\t0\torg.springframework.samples.petclinic/s...
3916 36\t0\torg.springframework.samples.petclinic/s...
3917 42\t0\torg.springframework.samples.petclinic/s...
3918 4\t0\tREADME.md

3919 rows × 1 columns


In [2]:
import pandas as pd
pd.read_csv("https://raw.githubusercontent.com/feststelltaste/software-analytics/master/notebooks/input/spring-petclinic/jacoco.csv")


Out[2]:
GROUP PACKAGE CLASS INSTRUCTION_MISSED INSTRUCTION_COVERED BRANCH_MISSED BRANCH_COVERED LINE_MISSED LINE_COVERED COMPLEXITY_MISSED COMPLEXITY_COVERED METHOD_MISSED METHOD_COVERED
0 JaCoCo Coverage Report org.springframework.samples.petclinic PetclinicInitializer 0 124 0 0 0 24 0 8 0 8
1 JaCoCo Coverage Report org.springframework.samples.petclinic.model NamedEntity 3 10 0 0 1 4 1 3 1 3
2 JaCoCo Coverage Report org.springframework.samples.petclinic.model Specialty 0 3 0 0 0 1 0 1 0 1
3 JaCoCo Coverage Report org.springframework.samples.petclinic.model PetType 0 3 0 0 0 1 0 1 0 1
4 JaCoCo Coverage Report org.springframework.samples.petclinic.model Vets 14 0 2 0 4 0 3 0 2 0
5 JaCoCo Coverage Report org.springframework.samples.petclinic.model Visit 0 29 0 0 0 12 0 7 0 7
6 JaCoCo Coverage Report org.springframework.samples.petclinic.model BaseEntity 0 17 0 2 0 5 0 5 0 4
7 JaCoCo Coverage Report org.springframework.samples.petclinic.model Person 0 17 0 0 0 7 0 5 0 5
8 JaCoCo Coverage Report org.springframework.samples.petclinic.model Owner 50 88 4 6 14 26 7 12 3 11
9 JaCoCo Coverage Report org.springframework.samples.petclinic.model Pet 9 56 1 1 3 18 2 10 1 10
10 JaCoCo Coverage Report org.springframework.samples.petclinic.model Vet 42 3 2 0 11 1 6 1 5 1
11 JaCoCo Coverage Report org.springframework.samples.petclinic.service ClinicServiceImpl 10 49 0 0 2 16 2 8 2 8
12 JaCoCo Coverage Report org.springframework.samples.petclinic.web OwnerController 57 85 6 4 13 23 7 7 2 7
13 JaCoCo Coverage Report org.springframework.samples.petclinic.web PetTypeFormatter 13 31 1 3 1 9 1 4 0 3
14 JaCoCo Coverage Report org.springframework.samples.petclinic.web PetController 43 69 6 4 12 18 7 7 2 7
15 JaCoCo Coverage Report org.springframework.samples.petclinic.web PetValidator 15 26 4 4 3 8 4 3 0 3
16 JaCoCo Coverage Report org.springframework.samples.petclinic.web VisitController 13 40 1 1 3 13 2 5 1 5
17 JaCoCo Coverage Report org.springframework.samples.petclinic.web VetController 31 6 0 0 7 3 2 1 2 1
18 JaCoCo Coverage Report org.springframework.samples.petclinic.web CrashController 5 3 0 0 1 1 1 1 1 1
19 JaCoCo Coverage Report org.springframework.samples.petclinic.util EntityUtils 32 0 6 0 6 0 5 0 2 0
20 JaCoCo Coverage Report org.springframework.samples.petclinic.util CallMonitoringAspect 57 51 3 1 11 13 7 2 5 2
21 JaCoCo Coverage Report org.springframework.samples.petclinic.reposito... JdbcVisitRowMapper 30 0 0 0 7 0 2 0 2 0
22 JaCoCo Coverage Report org.springframework.samples.petclinic.reposito... JdbcPetRepositoryImpl 134 0 2 0 33 0 6 0 5 0
23 JaCoCo Coverage Report org.springframework.samples.petclinic.reposito... JdbcVetRepositoryImpl 76 0 4 0 17 0 4 0 2 0
24 JaCoCo Coverage Report org.springframework.samples.petclinic.reposito... JdbcPetRowMapper 40 0 0 0 9 0 2 0 2 0
25 JaCoCo Coverage Report org.springframework.samples.petclinic.reposito... JdbcVetRepositoryImpl.new BeanPropertyRowMappe... 11 0 0 0 2 0 2 0 2 0
26 JaCoCo Coverage Report org.springframework.samples.petclinic.reposito... JdbcVisitRepositoryImpl 112 0 4 0 26 0 6 0 4 0
27 JaCoCo Coverage Report org.springframework.samples.petclinic.reposito... JdbcPet 17 0 0 0 7 0 5 0 5 0
28 JaCoCo Coverage Report org.springframework.samples.petclinic.reposito... JdbcPetVisitExtractor 29 0 2 0 8 0 5 0 4 0
29 JaCoCo Coverage Report org.springframework.samples.petclinic.reposito... JdbcOwnerRepositoryImpl 183 0 6 0 43 0 10 0 7 0
30 JaCoCo Coverage Report org.springframework.samples.petclinic.reposito... JpaVisitRepositoryImpl 18 12 1 1 4 4 2 2 1 2
31 JaCoCo Coverage Report org.springframework.samples.petclinic.reposito... JpaOwnerRepositoryImpl 5 47 1 1 1 10 1 4 0 4
32 JaCoCo Coverage Report org.springframework.samples.petclinic.reposito... JpaVetRepositoryImpl 6 3 0 0 1 1 1 1 1 1
33 JaCoCo Coverage Report org.springframework.samples.petclinic.reposito... JpaPetRepositoryImpl 5 26 1 1 1 6 1 4 0 4

In [10]:
URL="https://en.wikipedia.org/wiki/All-time_table_of_the_FIFA_World_Cup"
wc_table = pd.read_html(URL, header=0, index_col=0)[0]
wc_table.head()


Out[10]:
Team Part's Pld W D L GF GA GD Pts Avg Pts Best finish
Pos
1 Brazil 20 104 70 17 17 221 102 119 227 2.18 1 !Winner (5 Times)
2 Germany[1] 18 106 66 20 20 224 121 103 218 2.06 1 !Winner (4 Times)
3 Italy 18 83 45 21 17 128 77 51 156 1.88 1 !Winner (4 Times)
4 Argentina 16 77 42 14 21 131 84 47 140 1.82 1 !Winner (2 Times)
5 Spain 14 59 29 12 18 92 66 26 99 1.68 1 !Winner (1 Time)

In [17]:
wc_table[wc_table['W'] == wc_table['W'].max()]


Out[17]:
Team Part's Pld W D L GF GA GD Pts Avg Pts Best finish
Pos
1 Brazil 20 104 70 17 17 221 102 119 227 2.18 1 !Winner (5 Times)